KS DB Merge Tools logo KS DB Merge Tools
database diff & merge
AccdbMerge logo for MS Access
aka AccdbMerge
KS DB Merge Tools for Oracle logo
KS DB Merge Tools for MySQL logo
MssqlMerge logo
KS DB Merge Tools for PostgreSQL logo
KS DB Merge Tools for SQLite 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 Project changes summary use case) and 1click on Table definitions:

for MS Access, 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 MS Access, 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 4OK to apply changes:

for MS Access, object list select table click merge and set up options

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

for MS Access, table structure diff tab select columns and merge

Review changes, 5select items you want to merge, click 6Merge and wait for a progress completion.

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.