Execute Script Dialog

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:

for Cross-DBMS, execute data script dialog

Dialog header:

Please 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}
Row-level changes: expected {row count}
Execution status: {Status}

row count is a number of single-row INSERT/UPDATE/DELETE statements based on selected rows or tables. This count does not include results of batch statements like INSERT INTO x SELECT * FROM y. After script execution, this section also includes counts of processed and failed rows. Processed row is the script item processed by the database. For example, if we have a transaction, 5 rows to process, 4th row fails, then we have expected = 5, processed = 4 and failed = 1. Failed transaction is rolled back, no actual changed in database, but we still have 4 processed rows.

Dialog footer:

☐ Stop on first error (contraint violation, etc.) [ Run ] [ Close ]

The rest of area is divided into 3 major sections:

Script structure - script elements are organized into tree hierarchy. Each item contains a colored bullet indicating the status of the item: blue - not started, yellow - executing, green - succeed, red - failed.
Script for selected item [ Copy ] [ Save ] - SQL corresponding to selected Script structure item. If item includes sub-items, then it is combined SQL of sub-items. Text is truncated to 10k chars by default. If truncated, an appropriate notice shown:
Script is truncated for better performance.
For detailed analysis please review individual child items in the Script structure panel.
To view full script, click Show all.
with a Show all button. If first sub-item is more than 10k chars, then it is included without truncation. Even if truncated to 10k, Save will produce a file with a whole text, and Copy - with a text truncated to 1 million chars.
Execution result [ Copy ] [ Save ] - execution result of selected item. If item fails, includes the error message from the database engine.

Script structure does not include items for individual rows. It contains items corresponding to processed tables, and each table name also includes number of rows to be merged or deleted. If selected, script for selected item shows scripts for individual rows and first/previous/next/last buttons to scroll rows.

Run button tries to execute all script items one by one. In case of error:

If 'Stop on first error' selected - remaining items are not executed.
If error happens inside transaction - transaction is rolled back, remaining transaction items are not executed.

Free Version Limitations

No 'Show all' button, Copy and Save produce only shows script. So large scripts can be executed, but result of Copy/Save is truncated the same way as on UI
Row counts are not shown
No First row/Last row buttons

Last updated: 2025-07-01