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

RickL

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.

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

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.