Solved

Export documents uploaded inside Database

Posted on 2014-11-16
4
117 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:amucinobluedot
  • 2
4 Comments
 
LVL 13

Assisted Solution

by:sameer2010
sameer2010 earned 250 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 47

Accepted Solution

by:
Vitor Montalvão earned 250 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:amucinobluedot
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:amucinobluedot
ID: 40447887
Thanks
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…

813 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now