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
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 6:25 pm
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!
- 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