KS DB Merge Tools logo KS DB Merge Tools
database diff & merge
KS DB Merge Tools for MySQL logo for MySQL
and MariaDB
AccdbMerge logo
MssqlMerge logo
KS DB Merge Tools for SQLite logo
KS DB Merge Tools for PostgreSQL logo
KS DB Merge Tools for Cross-DBMS logo
KS DB Merge Tools for Oracle logo
KS DB Merge Tools   /  for MySQL   /  Use Cases: Diff & merge table data

Diff & merge table data

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

for MySQL, 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 MySQL, 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 MySQL, 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 MySQL, data diff select records and columns to merge