SQL comparison and synchronization automation capabilities
Published 08 February 2013
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.
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
