KS DB Merge Tools logo KS DB Merge Tools
database diff & merge
MssqlMerge logo for SQL Server
aka MssqlMerge
KS DB Merge Tools for Oracle logo
KS DB Merge Tools for MySQL logo
KS DB Merge Tools for PostgreSQL logo
KS DB Merge Tools for SQLite logo
AccdbMerge logo
KS DB Merge Tools for Cross-DBMS logo
KS DB Merge Tools All-In-One license

Diff & merge table data

Open databases (see Schema changes summary use case) and 1click on Table definitions:

for SQL Server, home tab click table definitions

to open Object list tab with tables. Note that rows highlight here is related only to column definition changes (column names, types, etc) and not related to data changes. Then 2click 'Compare data' for the required table:

for SQL Server, object list click compare data

to open Data diff tab with result. Here you can 3apply filter to show only changed and/or new records:

for SQL Server, data diff can show new or changed

To merge data changes to the other side you need to 4select required records, if needed 5select required columns, 6click Merge, and then click 7'Run' in the opened merge confirmation dialog to apply changes:

for SQL Server, data diff select records and columns to merge