Updating Data using SQL Data Compare

srob35

So I am comparing a source and target table that has customer information in it - is there a way to update records that have changed and also insert new customer records?

Does SQL Data Compare have that functionality?

Our current customer tables have around 8 million plus records in it - so if there is an easier way to update and insert new records that would be the way to go.

Anyone have any experience with this?

chriskelly

Yes, this is possible. Once the comparison is complete, ensure that you have unchecked the whole column titled "target only". This means that when you deploy the changes then any rows that are only in the target will not be changed or deleted. But any other rows will be added or updated.

yslow

Hi Chiskelly. how can the 'target only' be uncheck if i am using the command line to deploy? please advise.

chriskelly

This document may help
http://documentation.red-gate.com/displ ... mmand+line

But the option that may help you is /Exclude:Missing.

yslow

Thanks chriskelly.

what about the option : /Include:Missing /Include:Different

I would like to INSERT & UPDATE to the target but exclude delete.

is it ok if i am using the 2 options together?

The option should be placed after the target? or just simply put in the command line?

Thanks in advance.