Skip to main content

Export data from Standard Database tables without SQL Server Management Studio


QAID # 17246 Published

Question / Problem:

When using the Standard Kofax Capture database, is it possible to export data from tables for review without having SQL Server Management Studio available?

Answer / Solution:

Yes, it is possible to export data from SQL tables, using the Microsoft SQL bcp tool installed as part of Microsoft SQL Server.

Please see the MSDN library for detailed information about bcp and ats command line arguments.

To export the data from the Users table for example to a text file use the following command:

bcp Acsystem.dbo.Users out c:\temp\bcpUsersDump.txt -c -S .\ASCENTCAPTURE –Usa

The above command will dump the data from the Users table to a file in the temp folder named

Applies to: 

Product Version

Keywords: BCP, Bulk Copy, Export database table, Export table data