• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 144
  • Last Modified:

Free Tool to collect documents from a database

Hi

I have around 1300 documents in a database which i need to extract and save to a folder.

This database is connected to a system and it is posssible to open each document and save it that way, but due to the quantity i was wondering if there was a tool to collect these documents automatically?

Any help would be appreciated,

Rich
0
Richiep86
Asked:
Richiep86
  • 2
1 Solution
 
Lee SavidgeCommented:
0
 
Lee SavidgeCommented:
This might be quicker:

-- Export CLOB

DECLARE @BCPcommand NVARCHAR(1024)

SET @BCPcommand = 'bcp "SELECT TOP 1 Doc FROM tempdb.dbo.TestCLOB" queryout "K:\temp\CLOBTestOut.txt"  -T -c -C RAW -SYOURSERVER'

EXEC xp_cmdshell @BCPcommand

GO

DROP  TABLE TestCLOB

Open in new window


From here: http://www.sqlusa.com/bestpractices/documentimportexport/
0
 
Richiep86Author Commented:
This was helpful - 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.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now