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

In a project, is there a way to compare the data in two database tables but only deploy differences?

I have a SQL Data Compare project that compares two tables from two databases (source and target).  When the differences are found, I would only like to deploy ONLY what exists in both source and target database tables and NOT deploy what is in source but not in target.  In essence, I only want to do updates to the target and not do inserts.  Appreciate any ideas.
RickL
0

Comments

2 comments

Sort by
  • Tianjiao_Li
    Hi @RickL

    I'm afraid there isn't such setting within the project file or option to be used on command line. 

    I'll speak to the development team to confirm it and let you know.
    Tianjiao_Li
    0
  • Tianjiao_Li
    Hi @RickL

    It's not possible to do just update with project file. However, you should be able to use  /Include:Different​ on the command line to only include those that are different.
    Tianjiao_Li
    0

Add comment

Please sign in to leave a comment.