Change Key during Update

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?

mark_anderson_us June 14, 2016 13:50

Comments

1 comment

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,

Andrew P June 17, 2016 19:02

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Change Key during Update

Comments

Add comment