Updating Data using SQL Data Compare

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

Updating Data using SQL Data Compare

Postby srob35 » Tue May 14, 2013 10:13 pm

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?
srob35
 
Posts: 1
Joined: Tue May 14, 2013 10:10 pm

Postby chriskelly » Fri May 17, 2013 10:21 am

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.
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby yslow » Tue Oct 22, 2013 10:11 am

Hi Chiskelly. how can the 'target only' be uncheck if i am using the command line to deploy? please advise.
yslow
 
Posts: 3
Joined: Tue Oct 22, 2013 8:37 am

Postby chriskelly » Tue Oct 22, 2013 10:30 am

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

But the option that may help you is /Exclude:Missing.
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby yslow » Wed Oct 23, 2013 1:28 am

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.
yslow
 
Posts: 3
Joined: Tue Oct 22, 2013 8:37 am


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests