automate SQL Compare to run against several target servers

[dbdmora]

What is the best way to automate SQL Compare to run against several target servers and put the differences it finds in either .HTML or xml format. I do not want to change the target servers but get a report on the difference first.

Thanks for any info.

[David Atkinson]

Invoke the command line (assuming you have the pro version of SQL Compare).

Loop through your database target names using these switches:

sqlcompare.exe /s1:yoursourceserver /db1:yoursourcedatabase /s2:yourtargetdb /db2:yourtargetdb /reporttype:Interactive /report:yourreport.html /force

There are a number of different report types you can try. More info here:
http://www.red-gate.com/supportcenter/content/SQL_Compare/help/10.0/sc_cl_Switches_in_the_cl

David Atkinson
Red Gate