Command line across multiple servers

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Command line across multiple servers

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

Hi,

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.

-PrestigeTech
PrestigeTech
 
Posts: 1
Joined: Thu Dec 27, 2012 6:25 pm

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

Hi,

It took me a while to get to the right information and the best source I have found is here: http://www.red-gate.com/supportcenter/C ... _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!

Chris
ChrisGodfree
 
Posts: 7
Joined: Thu May 10, 2012 9:02 am


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests

cron