KS DB Merge Tools
 
for Microsoft Access
aka AccdbMerge
for SQL Server
aka MssqlMerge
for MySQL
and MariaDB
for SQLite
 

Diff & merge table data

1Click 'Open database(s)' toolbar button:

In the opened dialog 2specify database connectivity options and 3click 'OK':

4wait a bit for a progress:

5Click on total or changed count for 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 6click 'Compare data' for the required table:

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

To merge data changes to the other side you need to 8select required records, if needed 9select required columns and 10click Merge:

It will open merge confirmation dialog with synchronization script. Click 11'Run' to apply changes: