How can we help you today? How can we help you today?

automate SQL Compare to run against several target servers

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.
dbdmora
0

Comments

1 comment

Sort by
  • 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/c ... _in_the_cl

    David Atkinson
    Red Gate
    David Atkinson
    0

Add comment

Please sign in to leave a comment.