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 Modified
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 Modified
4. Click Compare.

...

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

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

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

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

Step 4: Synchronize Schemas

...

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

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.

...