compare all databases at once rather then one by on

• 
  Thank you for your post into the forum.
  
  We receive this question occasionally when answering pre-sales questions. Unfortunately you cannot perform a multiple database comparison using the SQL Compare GUI.
  
  However, you may be able to achieve your goal using the SQL Compare Command Line Interface (CLI) available through the Professional Edition. (if you are evaluating SQL Compare, you will be using the Professional Edition).
  
  Using the CLI, you will be able to create a batch that will compare multiple data sources by scheduling a single file. For example:
  

  sqlcompare.exe /Server1:MyServer1 /database1:AdventureWorks /Server2:MyServer2 /database2:Adventureworks /out:MyCompare1.txt /force
  
  sqlcompare.exe /Server1:MyServer1/database1:Northwind /Server2:MyServer2 /database2:Northwind /out:MyCompare2.txt /force
  
  sqlcompare.exe /Server1:MyServer1/database1:Pubs /Server2:MyServer2 /database2:Pubs /out:MyCompare3.txt /force
  

  
  You are still essentially comparing two databases at a time, but using the CLI you can combine each comparison to run one after the other.
  
  Further information can be found using this link to the help information regarding SQL Compare in the 'Learning SQL Compare' section ->The Command Line Interface:
  http://www.red-gate.com/supportcenter/P ... %20Compare
  
  I hope the above answers your question.
  
  Many Thanks
  Eddie

  Eddie D December 13, 2010 06:53

  - 0 +

Add comment

Please sign in to leave a comment.