How to Automate Comparisons
Saving (recording) Comparison Session
The comparison session needs to be recorded first so that it will be possible to replay it later with the command line.
To record a comparison process please click the button "Save" present on all screens displaying the results of the comparisons.
When saving the process, SCT automatically generates Comparison Id, which is needed when running SCT from the command line.
Command Line Parameter
The syntax for the command line is simple: /RunSavedComp n, where n indicates the Id of the saved comparison.
Here is an example of a command-line parameter:
"C:\Program Files\SQL Server Comparison Tool\sct.exe" /RunSavedComp 4
where 4 represents the Id of the comparison process to be run.
Replaying Comparison Session
You can run pre-saved comparison from the script, scheduler or any other utility that can launch SCT with the command line.
Our customers love SQL Server Comparison Tool
I have googled something like SQL Comparison Tool and I found some things including yours. I have tested few of them and I decided to buy yours (pretty good price). Nice tool to have, saves me a lot of time! Great job.
Richard A. Satin
This is a wonderful tool and I use it all the time. ... In the short time that I have been using it, the question is, how did I ever get along without.