Change Key during Update

mark_anderson_us

I am inserting data from a source table (several actually). The PK is an int (60 in the source table), but in the target 60 has been used, so I need to change anything with 60 in the source field to be 74 when inserted into the target.

Is there a way to do this?

Andrew P

Thanks for contacting us!
I would recommend generating the deployment scripts using SQL Data Compare- the edit the script with a find/replace tool in SSMS, Notepad, etc.
You can also filter the comparison using the Where clause editor https://documentation.red-gate.com/disp ... ERE+clause

If neither of those work then this might be a good feature request for our Uservoice forum https://redgate.uservoice.com/forums/14 ... ta-compare

Kind Regards,