Export documents uploaded inside Database

Using:  MS SQL and IIS7

I am importing data from one database to another.

System # 1 has documents uploaded inside the database. I am not familiar on how this is done and how to export them to be actual documents again (Like a word document or an excel file, or PDF)

System # 2 has a path to where the physical documents are stored (The actual word, excel or PDF file).

I need to export all documents from System # 1 to System # 2.

How can I export all those documents to a folder and convert them from what looks like a Blob in the table to actual files ?
LVL 1
AleksAsked:
Who is Participating?
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Can you post there the schema from the tables so you can see how those files are stored (which data type are used)?
0
 
sameer2010Commented:
Hi,

This can be easily achieved if ext for file is known, using BCP. Are you storing ext somewhere?

Thanks,
Sam
0
 
AleksAuthor Commented:
There is a table with the name of the document in one field and the extension of the document in another. As it turns out the documents are stored on a folder and not the database itself. Ill close this thread, thanks for the help.
0
 
AleksAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.