How can we store comparison data in an SQL table using the SQL Data Compare command line?

Amol_Gurav

How can we store comparison data in an SQL table using the SQL Data Compare command line?
We are comparing the same table across two databases(source & target) using the command line and deploying the script generated by the Redgate tool to the target database.
Our requirement is to store the primary key values of the table in a physical table, along with information indicating whether each row will be updated or inserted during deployment. Is this supported in Redgate? If yes, how can it be achieved?

Dan_J

Hi @Amol_Gurav

Thanks for reaching out to us regarding this.

Unfortunately this isn't possible directly within SQL Data Compare, however you can generate the CSV file results report file (https://documentation.red-gate.com/sdc/reviewing-the-comparison-results/exporting-the-comparison-results) and import the data from that file into the required database table.