Online Documentation for DB Comparer for SQL Server

All the comparison options can be saved in Project (*.scp) files. A project file can be also used in the Console version of DB Comparer for SQL Server.

For your convenience the console version of DB Comparer for SQL Server is included in the distribution package of the utility. The command line utility is intended for quick database structure comparison and synchronization and further scheduling

Usage

<path to DB Comparer for SQL Server console application>\MsComparerC.exe Projectfile [scriptfile] [logfile] [/E] [/B] [/L]

Projectfile

Stands for the *.scp file to be used as the console version execution parameter. See Opening / Saving Project for instructions on saving project files.

Scriptfile

Specify the output file name to save the modification script generated by the utility. If not specified, the script will be saved as Projectfile.sql in the home directory of DB Comparer for SQL Server.

Logfile

Specify the custom log file name.

/E

Execute generated script after comparison.

/L

Use the same localization in the console version as in the Wizard Application

/B

Use this parameter to run the application in the background mode. No console window will appear.

/A

Analyze renamed objects.

Examples:

"C:\Program Files\EMS\DB Comparer for SQL Server\MsComparerC.exe"

DBComparer_Project.scp

Upon running the command line utility, the modification script will be generated into DBComparer_Project.sql

"C:\Program Files\EMS\DB Comparer for SQL Server\MsComparerC.exe"

DBComparer_MS.scp Result.sql

Upon running the command line utility, the modification script will be generated into Result.sql

"C:\Program Files\EMS\DB Comparer for SQL Server\MsComparerC.exe"

DBComparer_MS.scp Result.sql /E

Upon running the command line utility, the modification script will be generated into Result.sql and executed.

Note: The following exit codes can be returned by DB Comparer for SQL Server to the operating system after performing the latest task:

0 - successful completion;

1 - error(s) occurred during task performing;

2 - fatal error occurred. The task was not performed.