KS DB Merge Tools logo KS DB Merge Tools
database diff & merge
KS DB Merge Tools for PostgreSQL logo for PostgreSQL
 
KS DB Merge Tools for Oracle logo
KS DB Merge Tools for MySQL logo
MssqlMerge 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

Compare and synchronize table definition

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

for PostgreSQL, home tab click table definitions

You can also click on New or Changed counts to see only new or changed tables respectively. Review changes in the opened Object list tab:

for PostgreSQL, object list review table definitions changes

New tables can be merged right from here: 2select required tables and 3click merge button. This will open a merge confirmation dialog, click 4Run to apply changes:

for PostgreSQL, object list select table click merge and run script

To merge changed table definition click on table name to open Table structure diff tab:

for PostgreSQL, table structure diff tab

Review changes, 5select items you want to merge, click 6Merge and then 7Run in the opened confirmation dialog to apply changes:

for PostgreSQL, table structure diff tab select columns and merge

Please note that these table definition changes do not affect data. So for example if you merge new column then it is populated with NULL or its default values. See Diff & merge table data use case to sync data if needed.