Command line across multiple servers

Forum for users of SQL Compare schema synchronization utility

Command line across multiple servers

Postby PrestigeTech » Thu Dec 27, 2012 5:31 pm


I'm a first time poster wondering how to set up command line calls to sync databases from a production server to a development server. Ultimately, I want to schedule scripts to run overnight that will produce a mirror copy of production in development. I've spent some time looking at the documentation and searching for examples but have come up short.

Many thanks for any examples or help you can provide.

Posts: 1
Joined: Thu Dec 27, 2012 5:25 pm

Postby ChrisGodfree » Fri Jan 11, 2013 3:30 pm


It took me a while to get to the right information and the best source I have found is here: ... _in_the_cl

At the simplest level you need this

"c:\\Program Files\\Red Gate\\SQL Compare 10\\SQLCompare" /db1:<source database> /s1:<source database server> /db2:<target database> /s2:<target database server> /sync

Hope this helps!

Posts: 7
Joined: Thu May 10, 2012 8:02 am

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests