Red Gate forums :: View topic - automate SQL Compare to run against several target servers
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

automate SQL Compare to run against several target servers

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
dbdmora



Joined: 21 Nov 2011
Posts: 33
Location: Atlanta, GA

PostPosted: Wed Jun 13, 2012 7:21 pm    Post subject: automate SQL Compare to run against several target servers Reply with quote

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.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1120
Location: Twitter: @dtabase

PostPosted: Wed Jun 13, 2012 8:47 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group