This dialog can be displayed to request parameters for the upcoming data merge/delete execution. The dialog is triggered by the Merge or Delete actions in the Data diff tab.
The Free version excludes some options and just warns about potential limitations instead:
The dialog contains the following sections.
You're going to {merge or delete} selected rows
Target database: {Database display name}
Data merge and deletion does not make any backup, please make sure that you've done it yourself if needed.
If disabled, DB engine will generate new values which most likely will be different
☐ Import existing AutoNumber values for new rows
You've selected all rows on the current data page, but there are more rows on other pages.The Free version simply warns that only the current page will be processed:
Do you want to process all rows from all pages?
☐ Process all pages
You've selected all rows on the current data page, but there are more rows on other pages which are not going to be processed.
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
The default state of Auto-generated primary key values, Merge all pages, and Transactions options is taken from previous confirmation.