Skip to main content
Kofax

Export data from Standard Database tables without SQL Server Management Studio

17246

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
    bcpUsersDump.txt.

Applies to: 

Product Version
CAPTURE 10.0
  10.1
  10.2
  11.0

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