KS DB Merge Tools logo KS DB Merge Tools
database diff & merge
KS DB Merge Tools for Oracle logo for Oracle
 
KS DB Merge Tools for MySQL logo
MssqlMerge 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 Oracle, 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 Oracle, object list click compare data

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

for Oracle, data diff can show new or changed

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

for Oracle, data diff select rows and columns to merge