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.

Usage:

<path to Data Comparer for SQL Server console application>\MsDataComparerC.exe TemplateFile [-L] [-B]

TemplateFile

Stands for the *.edc template file to be used as the console version execution parameter

[-L]

Selects current localization set in Wizard Application (GUI)

[-B]

Use this parameter in the command line to run the console version of Data Comparer for SQL Server in the background mode

[-LOG]

This parameter sets path to the log file. By default the log is written to the program's folder.

Example:

"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;