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

Deploy only data changes for a selection of tables using SQL Data Compare

Dear Support- i'mlooking to  automate the SQL Data Compare Project that compare a selection of tables in a database from different servers  and deploy changes where data is different (like a delta load) into test environment. I understtodthat we can automat this via XML + Commandline utility and schedule this on SQL Agetn Job. Could you please send me any instructions you have for me to set this up. Many thanks in advance.
Eagnar
0

Comments

1 comment

Sort by
  • Tianjiao_Li
    Sadly there isn't any TSQL scripts that can be run via a SQL Agent job that will allow a user to use the SQL Data Compare Command Line to automate a comparison.

    However, you can run a batch file that can be scheduled via the Windows Scheduler to automate your comparisons. All the available command line syntax and switches can be found: https://documentation.red-gate.com/sdc13/using-the-command-line
    Tianjiao_Li
    0

Add comment

Please sign in to leave a comment.