Page History

...

1. In the Servers pane, connect to a database, and then select the C##AQUA_DEVELOPMENT and the C##AQUA_TEST schemas.
2. Right-click the selected schemas and then click Schema Synchronization.
   Image RemovedImage Added
3. In the Schema Synchronization Tool, select the schema objects, the source and target objects, and the recommended options as shown in the below screenshot.
   Image RemovedImage Added
4. Click Compare.

Step 3: Select Objects for Synchronization

The Schema Compare Results tab displays the comparison result in the default set view, Type of difference.
Image RemovedImage Added

1. View and analyze the schema compare result in these states.

   State	Description
   Image Removed Image Added	Objects exist in both schemas and are identical.
   Image Removed Image Added	Objects exist in both schemas but are different.
   Image Removed Image Added	Objects exist in the AQUA_DEVELOPMENT schema but not in the AQUA_TEST schema.
   Image Removed Image Added	Objects exist in the AQUA_TEST schema but not in the AQUA_DEVELOPMENT schema.

2. From Image Removed stateFrom Image Added state, click an object to view its DDL script differences in the SQL Differences pane.
   Image RemovedImage Added
3. Right-click anywhere in the upper pane and then click Synchronize All Items. 
   Image RemovedImage Added

Step 4: Synchronize Schemas

...

1. In the Review Dependencies tab, verify the dependencies, and then click Next.
   Image RemovedImage Added
    
2. In the Map Missing Columns tab, map the target column with the source column, and click Next.
   Image RemovedImage Added
    
3. In the Configure Script tab, choose an appropriate action for each issue, and click Next.
   Image RemovedImage Added
    
4. In the Options tab, ensure that you select the appropriate options, and click Next.
   Image RemovedImage Added
    
5. In the Warnings tab, review the warnings that Schema Synchronization encountered while generating the deployment script.
   Image RemovedImage Added
    
6. Open the Summary tab and understand the actions and modifications that Schema Synchronization will perform on the objects of the target schema.
   Image RemovedImage Added
    
7. Open the Deployment Script tab and view and analyze the deployment script.
   Image RemovedImage Added
    
8. After you have reviewed the deployment script, click Open Script in Query Analyzer > click  > execute the deployment script.
   

   Before executing the script, ensure that you have taken a backup of the target database.

   Image RemovedImage Added
9. Open the Schema Compare Results tab, click  to recompare the source and target schemas, and view the synchronized result. Some objects are displayed in the Different state because you had specified default values for NOT NULL columns. 
   Image RemovedImage Added

See Also

• For detailed information on the schema compare result, see Schema Compare Result and View SQL Script differences.
• For detailed information on the various tabs in the schema synchronization process, see Schema Synchronization.

...