Online Documentation for Data Comparer for SQL Server
Using Console Application
All the comparison options are set in template (*.edc) files. A template can be also used in the Console version of Data Comparer for SQL Server.
To create a template file, follow the instructions below:
- start Data Comparer for SQL Server Application wizard;
- set all the required options in all steps of the wizard;
- test the comparison and synchronization process at the last step;
- save all comparison and synchronization options in the template.
The easiest way to start Data Comparer for SQL Server console application is to double-click the generated *.edc template. The other way is to enter the command line and type the appropriate command.
<path to Data Comparer for SQL Server console application>\MsDataComparerC.exe TemplateFile [-L] [-B]
Stands for the *.edc template file to be used as the console version execution parameter
Selects current localization set in Wizard Application (GUI)
Use this parameter in the command line to run the console version of Data Comparer for SQL Server in the background mode
This parameter sets path to the log file. By default the log is written to the program's folder.
"C:\Program Files\EMS\Data Comparer for SQL Server\MsDataComparerC.exe" "C:\EMS\DataComparer\1st_sync.edc" -L -LOG"C:\Logs\datacomparer.log"
Note: The following exit codes can be returned by Data Comparer for SQL Server to the operating system after performing the latest task:
0 - successful completion;
1 - error(s) occurred during task performing;