Open menu
KS DB Merge Tools logo KS DB Merge Tools
database diff & merge
KS DB Merge Tools for Cross-DBMS logo for Cross-DBMS
 
KS DB Merge Tools for MySQL logo
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 All-In-One license
Other tools

Compare Table Definitions

In this use case, we compare table definitions between two databases on different DBMS platforms. You’ll see which tables are new or missing, and review detailed schema differences — including column names, data types, and NULL/NOT NULL constraints. Most of these steps are available both for Free and Standard versions.

  1. Open databases (see the Schema Changes Summary use case) and click A Table definitions to open list of tables from both databases. Or, you can click other counts to show only new and/or changed table definitions.

    for Cross-DBMS, Home tab with schema changes summary, click NEW+CHG
  2. Opened Object list tab contains list of all table definitions. A table present in both databases with different columns is counted as changed (highlighted in red). A table missing in the target is counted as new (green). Use filter B to show only new and/or changed objects. The header shows C total counts, and the footer shows D text preview of the object definition changes. Click E on required table name to analyze specific table definition changes in detail.

    for Cross-DBMS, Object list tab with tables
  3. Opened Table structure diff tab contains F detailed information about table definition changes. New and changed columns and specific changed attributes are highlighted. The footer shows G differences for the selected item.

    for Cross-DBMS, Table structure diff tab