After you have reviewed the comparison results, you can select the objects you want to synchronize and run the synchronization wizard.
By default, all rows are selected for synchronization.
Use the checkboxes to undo the selection of rows for synchronization.
You can also use the Operation drop-down menu to select objects:
None is set by default for identical objects and cancels the selection of an object for synchronization. You can change it to Drop.
Drop is set by default for objects with the Only in Target status and means that the object will be dropped in the target schema. You can change it to None.
Create is set by default for objects with the Only in Source status and means that the object will be created in the target schema. You can change it to None.
Update is set for objects with the Different status and changes the target object according to the source object. You can change it to Drop or None.
dbForge Schema Compare for PostgreSQL automatically sets different statuses for compared objects to help you quickly analyze the differences. The statuses are as follows:
Schema synchronization can not be rolled back. It may alter or drop schema objects in your target schema. It is highly recommended to back up the target database before synchronization.
After you have selected objects, you can run the process of synchronization.
To synchronize the objects
1. To open the Schema Synchronization Wizard, click Synchronize objects to the target database.
2. Select one of the output options to manage the synchronization script:
3. To close the wizard and complete the synchronization process, click Synchronize.