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 ?