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

Automatically running the SDC file

The SQL Data Compare project file is configured very nicely now. I'd like to find a way to schedule it so it runs every day in a SQL Server job.

Is there a flag I can set so I can do the equivalent of the psuedo code below?
SQLDataCompare.exe RedGateTest1.sdc /quiet
AndreQ1
0

Comments

1 comment

Sort by
  • AndreQ1
    Apologies, after looking through SQLDataCompare /?, I found pretty much everything I'm looking for with this:
    c:Program Files (x86)Red GateSQL Data Compare 12SQLDataCompare.exe  /project:c:YourFolderHereRedgateTest.sdc /quiet /force /out:c:YourFolderHereOutput_Daily.txt /outputwidth:100 /scriptfile:c:YourFolderHereRedGateCompare.sql
    AndreQ1
    0

Add comment

Please sign in to leave a comment.