What are the challenges you face when working across database platforms? Take the survey
Options

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

RickLRickL Posts: 1 New member
edited August 16, 2018 9:50PM in SQL Data Compare
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.

Answers

Sign In or Register to comment.