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 Data diff tab to review scripts for data merge/delete actions:

for Cross-DBMS, execute data script dialog

If processed table has an autoincrement/identity column, this dialog shows Import existing autoincrement/identity values on INSERT option to merge the data with the same autoincrement 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-11