Online Documentation for DB Extract for SQL Server
Using console application
All the extraction options are set in template (*.ext) files. A template can be also used in the Console version of DB Extract for SQL Server
To create a template file, follow the instructions below:
- start DB Extract for SQL Server Wizard application;
- set all the required options in all steps of the wizard;
- test the extraction process at the last step;
- save all generation options in the template file.
The easiest way to start DB Extract for SQL Server console application is to double-click the generated *.ext configuration file. The other way is to enter the command line and type the appropriate command.
<path to DB Extract for SQL Server console application>\MSExtractC.exe TemplateFile [-L] [-B]
Stands for the *.ext template file to be used as the console version execution parameter
Use this parameter in the command line to run the console version of DB Extract for SQL Server in background mode
"C:\Program Files\EMS\MS SQL Extract\MSExtractC.exe" "C:\Program Files\EMS\MS SQL Extract\DBExtract1.ext" -L
Note: The result of the latest task performed by DB Extract for SQL Server can be found in the system variable '%ERRORLEVEL%'.
0 - successful completion;
1 - error(s) occurred during task performing;
2 - fatal error occurred. The task was not performed.