xSQL Schema Compare for Oracle Databases > Synchronizing Schemas > Working with the Synchronization Script |
The synchronization script will be displayed on a new window within the comparison session's tab. The new window is named with the [Connection]/[Schema] for which the script was generated and it contains two sub-tabs - the "Synchronization Script" tab contains the actual script whereas the "Synchronization Log" contains a summary of the actions that will be performed on the target database.
Warnings Section: please pay special attention to the warnings displayed at the top section of the synchronization script window. When the synchronization requires dropping objects like columns or tables that may contain data or in situations when the synchronization has to be performed through an intermediary table, schema compare will display a warning indicating the potential risk that such action carries.
Both the "ribbon" and a context menu allows you to save the script, copy it, print it, jump to a certain line in the script.
If you go back to the comparison results tab and redo the comparison the corresponding synchronization script may be out of sync - the script will not be re-generated automatically. To refresh the script click on "generate the script..." on the "comparison Results" tab.