This dialog is opened to confirm and customize batch data merge/delete action from the Batch data diff tab:
The dialog contains the following sections.
You're going to {merge or delete} data for selected tables.The next warning is shown only if we are going to process tables with changed column definitions:
Target database: {Database display name}
Some of selected tables have 'Changed columns'=Yes, this means that:The next warning is displayed if there are any tables that cannot be merged due to missing or changed key definitions:
- 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.
Your selection also contains one or more views or tables without common key - they are not going to be processed.
Data merge and deletion does not make any backup, please make sure that you've done it yourself if needed.
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
Wrap table data operations in a transaction on the target database, with rollback on any first failure.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.
Can also provide better performance.
☐ With transaction
