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

Schema Changes Summary

In this use case, we connect to two MySQL or MariaDB databases, read object definitions, and get a schema changes summary — the total counts of new and changed tables, views, and other objects. This use case is also the starting point for most others: before comparing or synchronizing objects or data, you first need to connect to the databases and load their definitions.

  1. Click A 'Open database(s)' to start connecting to your databases.

    for MySQL, home tab blank
  2. Specify connection settings at B. If both databases are on the same server, enable C 'Use the same options' to reuse settings for the second database (only DB name needed). Click D 'OK'.

    for MySQL, home tab open databases
  3. Wait while the tool loads the database definitions. You’ll see a progress indicator E.

    for MySQL, progress indicator while loading
  4. After loading, you’ll see the total, new, and changed object counts for each type (tables, views, stored procedures, etc.).

    for MySQL, home tab schema changes summary