Page History

Identifying the data differences between two databases helps you as a DBA/Developer in many ways but often your job does not end there - you need to migrate those changes from one database to another. IDERA SQL Data Compare allows you to do just that - after comparing the contents of two databases you can use it to generate the synchronization script - a T-SQL script that will update the target database (or just the selected tables/rows) to make it the same as the source database.

...

In case you do not wish to delete the rows that only exist on the target database you can change the comparison options so that those rows are not included in the synchronization.