Command line across multiple servers
PrestigeTech
Posts: 2
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
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
Comments
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