How can we help you today? How can we help you today?

Updating Data using SQL Data Compare

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
0

Comments

4 comments

Sort by
  • 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.
    chriskelly
    0
  • yslow
    Hi Chiskelly. how can the 'target only' be uncheck if i am using the command line to deploy? please advise.
    yslow
    0
  • chriskelly
    This document may help
    http://documentation.red-gate.com/displ ... mmand+line

    But the option that may help you is /Exclude:Missing.
    chriskelly
    0
  • 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.
    yslow
    0

Add comment

Please sign in to leave a comment.