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

Automate commandline tool using a project

I am attempting to keep a reporting database in sync with our production database. There are about 13 tables, most without PK's, and require a custom key, made of several fields, for comparison. To try and simplify this, I have created a project that includes the requirements and works great to sync the tables manually. But, it does not work when running it from the command line. It appears to do the comparison, but it does not run the update. What am I missing?

I'm currently using the the following syntax:
"C:\Program Files (x86)\Red Gate\SQL Data Compare 10\sqldatacompare.exe" /Project:"c:\DTS Executables\RedgateScripts\MyProject.sdc" /include:identical

Thanks in advance.
kdixon
0

Comments

2 comments

Sort by
  • Manfred.Castro
    I believe you are missing the synchronize switch.

    /Synchronize

    Alias: /sync

    Deploys the data after comparison.


    http://documentation.red-gate.com/displ ... mmand+line

    You command will become

    "C:\Program Files (x86)\Red Gate\SQL Data Compare 10\sqldatacompare.exe" /Project:"c:\DTS Executables\RedgateScripts\MyProject.sdc" /include:identical /sync
    Manfred.Castro
    0
  • kdixon
    Awesome! I knew it was something simple I was missing. I'll add that and give it a go.

    Thanks for the quick reply.
    kdixon
    0

Add comment

Please sign in to leave a comment.