November 2, 2005 at 8:11 am
I posted this in a general area - but maybe there are some strategies on the storing of PDF files in a table - and advice or debate would be wonderful.
November 2, 2005 at 2:59 pm
well, you might want to reiterate some detail...
first and formost: WHY?
why are you storing them in SQL Server?
What are you going to do with them?
How might they be accessed/used/collected...
Why don't you start by telling us the business problem that you've decided is being addressed by storing PDFs in SQL Server?
November 2, 2005 at 3:17 pm
Okay - we are taking a users text generating a single .pdf and then making it available to the rest of the community as a pdf. We will have hundreds of pdf files that are made available over time. We are using sql server and just have them in our data design - perhaps we should just store a physical path to a directory that houses the file - but the developer wanted to research the possibilities of storing the file itself in the db.
November 3, 2005 at 5:04 am
There's nothing really wrong with storing them in SQL Server - sometimes it can make things much easier as all of your data is in one place for backups and migration.
Create a column of type IMAGE and you can store the PDFs in it.
November 3, 2005 at 5:54 am
I posted in your other thread
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=234505
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply