Open menu
KS DB Merge Tools logo KS DB Merge Tools
database diff & merge
KS DB Merge Tools for MySQL logo for MySQL
and MariaDB
MssqlMerge logo
KS DB Merge Tools for PostgreSQL logo
KS DB Merge Tools for Oracle 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
Other tools

Diff & Merge Table Data

In this use case, we compare and synchronize data in a single MySQL or MariaDB table. You’ll see new and changed rows, review differences, and generate a merge script. Most of this functionality is available both for Free and Standard versions.

  1. Open databases (see the Schema Changes Summary use case) and A click Table definitions.

    for MySQL, Home tab click table definitions
  2. In the opened Object list, click B Compare data (only new or changed) for the required table.

    for MySQL, Object list tab click Compare data
  3. The Data diff tab opens, filtered to show only new or changed rows. Rows are identified by primary key (e.g., category_id). A row present in both databases with different values is counted as changed (highlighted in red). A row missing in the target is counted as new (green). Use filter C to show only new or only changed rows. The header shows D total counts, and the footer shows E column-level differences for the selected row. For large text values, click the column name in the footer F to open a separate Text diff tab with a value diff result.

    for MySQL, Data diff tab showing new and changed rows
  4. Click G Select all, then H Merge to generate a synchronization script for all displayed changes.

    for MySQL, Data diff - select all and merge
  5. Review merge settings in the dialog that appears, then click OK at I.

    for MySQL, data merge configuration
  6. In the Execute script dialog, click J Run to apply changes immediately, or use K Copy / Save to store the script for later.

    for MySQL, Execute script dialog with data merge script