SQL comparison and synchronization automation capabilities

Category: SDK, API & Command line
Date: 16 Dec 2010
Product: SQL Packager
In SQL Toolbelt Installer there are are three utilities - SQLCompare.exe; SQLDataCompare.exe and SQLPackager.exe. These are standalone executables capable of being placed into batch, VB Script, Perl or any other batch language, capable of performing all of the functions of the GUI driven equivalents.

The User Interface documentation and product help documentation do not describe all of the capabilities of these programs, but starting up an executable in a command prompt will reveal the all the usage syntax:

sqlcompare /? /verbose|more
sqldatacompare /? /verbose|more
sqlpackager /? /verbose|more

To produce a HTML document containing all the commands, use the "/html" switch.
sqlcompare /help /verbose /html >cmdhelp.html

Please note that these command-line utilities are only available for licence-holders of the "Professional Edition" of the tools. Previous to version 5, these were licensed as part of "SQL Toolkit", which includes them as well as API access to the comparison and synchronization libraries.

Document ID: KB200710000180 Keywords: compare,bundle,command,line,SQL

Was this article helpful?

Search support