Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Export documents uploaded inside Database

Posted on 2014-11-16
4
Medium Priority
?
125 Views
Last Modified: 2014-11-17
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 ?
0
Comment
Question by:Aleks
  • 2
4 Comments
 
LVL 13

Assisted Solution

by:sameer2010
sameer2010 earned 1000 total points
ID: 40446714
Hi,

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

Thanks,
Sam
0
 
LVL 52

Accepted Solution

by:
Vitor Montalvão earned 1000 total points
ID: 40446998
Can you post there the schema from the tables so you can see how those files are stored (which data type are used)?
0
 

Author Comment

by:Aleks
ID: 40447882
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
 

Author Closing Comment

by:Aleks
ID: 40447887
Thanks
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Does your audience prefer people in photos or no people? How can you best highlight what you’re selling? What are your competitors doing, and what can you do that is different and unique from them?  Continue reading to learn how to make your images …
Without even knowing it, most of us are using web applications on a daily basis.  In fact, Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We generally confuse these web applications to…
The viewer will learn how to dynamically set the form action using jQuery.
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question