How can we help you today? How can we help you today?

Command line across multiple servers

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
0

Comments

1 comment

Sort by
  • ChrisGodfree
    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
    0

Add comment

Please sign in to leave a comment.