xSQL Object

Synchronizing Databases - Executing Synchronization Script

 

After reviewing the synchronization script and making sure it is going to do what you intend, you can execute it. We strongly recommend that you make a full backup of the database before running the synchronization script.

You can execute the script directly from xSQL Object or open it in Query Analyzer or SSMS. Please pay attention to the "Action" section on the header of the synchronization script to make sure that the script will be executed against the correct database.

When you execute the synchronization script from within xSQL Object, by default xSQL Object will take a snapshot of the database schema that is about to be altered. This will allow you to potentially reverse the schema changes that you are going to perform.

Important: if columns or tables that contain data will be dropped by the synchronization script the only way to reverse the changes will be to restore the data from a full backup of the database. The schema snapshot only enables you to reverse schema changes but not the data that may be lost.