Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hezviz
Starting Member
3 Posts |
 Posted - 2007-05-16 : 12:52:28
|
| I'm new to forums so please forgive any errors-I have a table called Contributors that stores pdf's of legal documents that are created from our On-line Contract app. I need to be able to extract the pdf files and name each one uniquely. It was suggested that I use BCP- but how do I get BCP extract the pdf file (which is stored as a BLOB) from each line of the table, and uniquely name it?Heather Vizina |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-16 : 16:00:22
|
| Do you really REALLY need to store the PDF files in the database?Whilst there are a very VERY few good reasons for storing files within the database itself, the considered wisdom is to store the physical file using the Operating System, and only store the path / FileName in the database itself.Kristen |
 |
|
|
hezviz
Starting Member
3 Posts |
Posted - 2007-05-16 : 16:49:38
|
| Thanks for replying Kristen. Unfortunately, the pdf's will be stored in the orig Db on the prod server. My boss helped me figure out how to use a while loop to go.ThanksHeather Vizina |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-17 : 02:58:34
|
Glad you got it sorted, I doubt that will be the end of your problems with the approach though  |
|
|
|
fmoreno
Starting Member
1 Post |
Posted - 2007-05-21 : 16:33:06
|
quote:
Originally posted by hezviz
Thanks for replying Kristen. Unfortunately, the pdf's will be stored in the orig Db on the prod server. My boss helped me figure out how to use a while loop to go.ThanksHeather Vizina
Heather,I'm currently working on the same issue as you, trying to extract files from a sql db. If possible, would you please provide the script or sp you're using for naming the files? I've already have the file name on a field.Thank you!Fmor |
|
|
|
|
|
|
export PDF Files from SQL 2000 DB- NOW resolved