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 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 tab to review scripts for processed database objects:

for SQL Server, execute script dialog

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

for SQL Server, execute data script dialog

In case of data diff, if the processed table has an identity column, this dialog shows Import existing identity, sequence or other auto-generated primary key values on INSERT option to merge the data with the same auto-generated primary key values instead of generating new values. If applicable, enabled by default. If it is applicable (shown) and disabled - then even after merge Data Diff can still show changes because new records will get new IDs and will be considered as different.

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 SQL server - they will be shown here as well.

Free version limitations:

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

Last updated: 2023-10-02