Link to home
Start Free TrialLog in
Avatar of maqskywalker
maqskywalker

asked on

storing pdfs in sql server 2008

i have an application that generates some pdf files in a directory.

So for example in my application I have a folder called TestFolder that contains the following:

Testrecord1.pdf
Testrecord2.pdf
Testrecord3.pdf


I'm using sql server 2008.

Is it possible to store all those pdfs in into SQL Server?
What i mean is, is it even possible to store pdfs inside a sql server table?
If so what sql server data type is best to store those pdfs?
I mean if these were image files instead of pdfs I could store the images inside a table using image type for the data type. But I'm not sure about pdfs.

or
Is it better to just store the path to to each of these pdfs in a sql server table.
ASKER CERTIFIED SOLUTION
Avatar of Brian Crowe
Brian Crowe
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Agreed. Always try and avoid storing binary files in your database. Just store a reference to it far more efficient.