KS DB Merge Tools logo KS DB Merge Tools
Documentation
KS DB Merge Tools for PostgreSQL logo for PostgreSQL
 
KS DB Merge Tools for Oracle logo
KS DB Merge Tools for MySQL logo
MssqlMerge logo
KS DB Merge Tools for SQLite 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 actions.

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

for PostgreSQL, execute script dialog

and from Data diff and Batch data diff tabs to review scripts for data merge/delete actions:

for PostgreSQL, execute data script dialog

In case of data processing, the dialog has additional options:

  • With transaction
    (all changes will be rolled back on cancellation,
    can also make execution much faster)
  • Stop on first error
    (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:

  • Import existing serial, identity or other auto-generated primary key values on INSERT
    (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.

Free Version Limitations

  • Data merge/delete script has no Copy ALL to clipboard and Save ALL to file actions
  • Data row count to be processed is not shown
  • Data merge/delete - no First row/Last row buttons

Last updated: 2025-03-17