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.
It is opened from Object list, Table structure diff and View definition diff tabs to review scripts for processed database objects:
and from Data diff and Batch data diff tabs to review scripts for data merge/delete actions:
In case of data processing, the dialog has additional 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.
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.