<div>
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.
</div>


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.

<div>
<div class="content wysiwyg-content">
Using: &nbsp;MS SQL and IIS7<br />
<br />
I am importing data from one database to another. <br />
<br />
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)<br />
<br />
System # 2 has a path to where the physical documents are stored (The actual word, excel or PDF file).<br />
<br />
I need to export all documents from System # 1 to System # 2.<br />
<br />
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 ?
</div>
</div>


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 ?

Export documents uploaded inside Database

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

IIS is Internet Information Services, the web server included with Windows Server operating systems. All current versions are built on a modular architecture; modules can be added or removed individually so that those required for specific functionality are installed. The full installation of IIS includes HTTP, security, content, compression, caching, logging and diagnostics.

Microsoft IIS Web Server

Web development includes all aspects of presenting content on intranets and the Internet, including delivery development, protocols, languages and standards, server software, browser clients, databases and multimedia generation.