Red Gate forums :: View topic - Command line across multiple 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

Command line across multiple servers

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



Joined: 27 Dec 2012
Posts: 1

PostPosted: Thu Dec 27, 2012 6:31 pm    Post subject: Command line across multiple servers Reply with quote

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



Joined: 10 May 2012
Posts: 7

PostPosted: Fri Jan 11, 2013 4:30 pm    Post subject: Reply with quote

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/Content/SQL_Compare/help/10.2/sc_cl_Switches_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
Back to top
View user's profile Send private message
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