Synchronizing Schemas

This topic explains how to synchronize two database schemas.

Note
Schema synchronization can not be rolled back! It may alter or drop schema objects in your Target schema. It is highly recommended to backup the Target database before synchronization.

  1. Review the comparison results and select required objects for synchronization. Clear the checkboxes next to the objects you do not want to be synchronized. You can also select an object and then click Exclude Selection in the shortcut menu to exclude one from the synchronization process.
  2. Click the View Schema Update Script button on the Comparison toolbar.
  3. Click the Synchronize button to open the synchronization wizard. You can select what do you want to do with the synchronization script (either open or save).
  4. Click the Synchronize button to close the wizard and complete the synchronization process.

  5. Review the sync script, and then execute it by clicking the Execute button on the SQL toolbar.