Opened to review and run script for merge, replace and delete actions performed using merge to right,
merge to left,
replace to right,
replace to left,
delete left and
delete right toolbar actions.
This dialog is shown from the Data diff and Batch data diff tabs to review scripts for data merge/delete actions:
Dialog header:
You can review the merge script below and click Run to execute this script or copy it to clipboard/file for later use.
Target database: {Database display name}
Target table: {table}, records to be {merged or deleted}: {count}
Execution status: {status}
Dialog options:
(all changes will be rolled back on cancellation,
can also make execution much faster)
(for example - contraint violation, etc.
if transaction enabled, all changes rolled back)
If processed table has an auto-increment primary key in the target database, this dialog shows additional option:
(if not checked, DB engine will generate new values which most likely will be different)
If it is applicable (shown) and disabled - then even after merge table can still have changes because new rows will get new IDs and will be counted as different rows. Also, if such a primary key is used as a foreign key for any other table, then it can be non-desirable action and you probably need to use Id-Remap merge instead.
Data processing script is splinted into script items per row. The dialog contains additional buttons to scroll thru script items and buttons Copy ALL to clipboard / Save ALL to file for script items and their execution results. Since amount of rows can be bery big, Copy ALL result is limited to 1 million characters.
Run action executes displayed script, information about script execution will be shown in the bottom Execution result text area. If there will be any errors from database engine - they will be shown here as well. Data merge/delete execution result is individual for each script item, total number of errors shown in the Execution status label.