xSQL Object

Synchronizing Databases - Synchronization Script

 

Once you have made your selections you can generate the synchronization script to either make the schema of the database on the right side of the comparison the same as the schema of the database on the left side or the other way around.

The synchronization script will be displayed on a new tab that contains two sub-tabs – the “Synchronization Script” sub-tab contains the actual script whereas the “Synchronization Log” sub-tab contains a summary of the actions that will be performed on the 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 xSQL Object will display a warning indicating the potential risk that such action carries.

Note that 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.

You can save the script, copy, print, and open it with Sql Server 2000 Query Analyzer or Sql Server 2005 Management Studio.