KS DB Merge Tools logo KS DB Merge Tools
Documentation
KS DB Merge Tools for Oracle logo for Oracle
 
KS DB Merge Tools for MySQL logo
MssqlMerge 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 and Table structure diff tabs to review scripts for processed database objects:

for Oracle, execute script dialog

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

for Oracle, execute data script dialog

In case of data diff, if processed table has an identity column, this dialog shows Import existing IDENTITY values on INSERT option to merge the data with the same auto-increment 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-06