xSQL Data Compare

Review Synchronization Script

 

The data synchronization script will display on a new window that contains two tabs. The first tab called "Synchronization Script" contains the script itself whereas the second tab called "Synchronization Log" contains a summary of the actions that will be performed on the target database.

A handy context menu allows you to save the script, copy it, print it and add line numbers to it.

Here you can review the script to ensure that it is doing what you intend it to do. You may want to start the review from the "Synchronization Log" - so that you can quickly identify the areas of the script that may require a closer look.

By default xSQL Data Compare generates a summary log, but you can choose to generate a detailed log by checking the "Generate detailed log" option on the Data Compare Options dialog box.

Refreshing the comparison and regenerating the script: while reviewing the script you may discover that you should have done something different on the options before running the compare - xSQL Data Compare allows you to change the options at any point during the process and simply hit the refresh icon on the toolbar to redo the comparison without having to go through the whole exercise of selecting columns and keys etc. You can not, however, refresh the synchronization script - simply close the synchronization script tab and re-generate the script after having refreshed the comparison results.

Openning the script in Query Analyzer or SSMS: from the script window you can "transfer" the script directly to Query Analyzer or SSMS assuming you have those tools installed on your machine. Simply right click anywhere on the script and click "Open with Query Analyzer" or "Open with Management Studio".