The data synchronization script will be displayed on a new window within the comparison tab. The new window is named with the <Oracle Connection>,<schema> for which the script was generated.
 |
If the data synchronization script is too big (exceeds 32MB), data compare will display the script partially, only the first 32MB-size block, in order to preserve the memory. If you wish the view the whole script, you can save it to a file and open it with a text editor. |
A handy context menu allows you to save the script, copy it, print it, add line numbers, jump to a certain line in the script, etc.
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. The synchronization log which can be accessed from the ribbon ("View Sync Log" button) or from the action links on the right panel contains a summary of the actions that will be performed on the target database.
Refreshing the comparison and regenerating the script: while reviewing the script you may discover that you should have done something different during the preparation phase before running the compare - data compare allows you to change the options at any point during the process and simply hit the "Refresh Result" button on the ribbon to redo the comparison without having to go through the whole exercise of selecting columns and keys etc. Note however that this "refresh" action does not affect the synchronization script that has been generated already. To refresh the script window simply generate the script again.
|
If the synchronization script contains Oracle LOB fields (CLOB, NCLOB or BLOB) whose size exceeds the maximum inline size supported by Oracle (4000 bytes), data compare creates an Oracle package to overcome this limitation. The package is created before the synchronization script starts, it updates the LOB fields in chunk of approximately 4000 bytes and it is dropped after the script finishes. |