Comments
1 comment
-
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.
Add comment
Please sign in to leave a comment.
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?