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

Eagnar

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.

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