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:

 

 

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;