KS DB Merge Tools logo KS DB Merge Tools
Documentation
MssqlMerge logo for SQL Server
aka MssqlMerge
KS DB Merge Tools for Oracle logo
KS DB Merge Tools for MySQL logo
KS DB Merge Tools for PostgreSQL logo
KS DB Merge Tools for SQL Server logo
AccdbMerge logo
KS DB Merge Tools for Cross-DBMS logo

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 buttons.

It is opened from Object list, Table structure diff and View definition diff tabs to review scripts for processed database objects:

for SQL Server, execute 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}
Execution status: {Status}

If we process table definitions and any of them has changed column order and application is configured to recognize such tables and changed, then the header includes an additional notice:

Some of selected changes are caused only by changed column order. Such changes can not be merged and these items will remain changed after completion of merge. You can uncheck 'Columns order' table definitions option in Settings to consider such tables as unchanged.

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.

This dialog is also shown from the Data diff and Batch data diff tabs to review scripts for data merge/delete actions:

for SQL Server, execute data script dialog

For data merge/delete, this dialog contains additional elements:

  • Header includes additional row:
    Row-level changes: expected {row count}
    It 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.
  • 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
  • Data merge/delete - row counts are not shown
  • Data merge/delete - no First row/Last row buttons

Last updated: 2025-06-19