Options

automate SQL Compare to run against several target servers

dbdmoradbdmora Posts: 50
edited June 13, 2012 3:47PM in SQL Compare Previous Versions
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.
· Share on Twitter

Comments

  • Options
    David AtkinsonDavid Atkinson Posts: 1,439 Rose Gold 2
    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
    Product Manager
    Redgate Software
    · Share on Twitter
Sign In or Register to comment.