KS DB Merge Tools logo KS DB Merge Tools
Documentation
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

Batch Data Merge Dialog

This dialog is opened to confirm and customize batch data merge/delete action from the Batch data diff tab:

for MS Access, batch data merge warning

The dialog contains the following sections.

Action

Section content:
You're going to {merge or delete} data for selected tables.
Target database: {Database display name}
The next warning is shown only if we are going to process tables with changed column definitions:
Some of selected tables have 'Changed columns'=Yes, this means that:
- source table may have columns that are not going to be merged,
- some column data types can be changed, data can be truncated or not merged at all.
The next warning is displayed if there are any tables that cannot be merged due to missing or changed key definitions:
Your selection also contains one or more views or tables without common key - they are not going to be processed.

Backup

Section content:
Data merge and deletion does not make any backup, please make sure that you've done it yourself if needed.

Scope and data options

This section asks for a desired new/changed rows filter to apply and allows to specify options related to that filter.
Please specify which rows should be {merged to or deleted in} the target database:
New  ○ Changed  ○ New and changed

If we are performing a merge (not deletion), then we may have additional options for script generation.

New and 'New and Changed' options provide an additional option for AutoNumber column values:

Some of selected tables have AutoNumber primary keys. If the following option is disabled, DB engine will generate new values which most likely will be different
Import existing AutoNumber values for new rows

In the case of merge with a 'New and Changed' filter, the dialog also suggests to delete new rows in the target database to ensure that the target rows match the source rows exactly:

It seems that you want to merge all changes to the target db. By default this option inserts missing rows and updates changed rows. However the target table may contain rows which are missing in the source and this will keep the set of rows different even after completion of merge. You can eliminate these changes in two ways: 1) after completion of Merge action run Delete action on the target db, or 2) select the option below:
Delete new rows in the target database

Transactions

Section content:
Wrap table data operations in a transaction on the target database, with rollback on any first failure.
Can also provide better performance.
With transaction
If enabled, application calls BeginTrans() DAO call before rows processing, and CommitTrans() in the end of successful execution. If any row fails, then execution is stopped and Rollback() call made.

Free Version Limitations

  • The whole dialog is not available

Last updated: 2025-07-17