|
-
 Originally Posted by daljitsb
Can we not store .tiff file as bfile - store it in file system and save the pointer to file in the database and keep the database small. What are the pros and cons for different options.
The idea of storing files outside the database is nothing new; think about backup consistency.
Originally Posted by daljitsb
Our application is going to be configurable to work with both sqlserver and oracle db and We do want to store the files on file system in sqlserver db.
Nice idea, hard to implement. Your backend code will be totally different.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote