For the Oracle Database Server, to compare and synchronize changes from the C##AQUA_DEVELOPMENT (source) schema to the C##AQUA_TEST (target) schema, perform these steps. 

Step 1: Set up Schemas

  • Copy the SQL Script and execute it in the Query Analyzer.

This SQL Script is compatible with the Oracle Database Server Version 10g or higher.

Step 2: Compare Schemas

  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.
  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.
  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.

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

    StateDescription

    		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.
  3. Right-click anywhere in the upper pane and then click Synchronize All Items. 

Step 4: Synchronize Schemas

Schema Synchronization creates DDL scripts that will synchronize all schema objects you have selected in Schema Compare Results tab.

Before starting with schema synchronization, ensure that you have taken a backup of the target database.

  1. In the Review Dependencies tab, verify the dependencies, and then click Next.

     
  2. In the Map Missing Columns tab, map the target column with the source column, and click Next.

     
  3. In the Configure Script tab, choose an appropriate action for each issue, and click Next.

     
  4. In the Options tab, ensure that you select the appropriate options, and click Next.

     
  5. In the Warnings tab, review the warnings that Schema Synchronization encountered while generating the deployment script.

     
  6. Open the Summary tab and understand the actions and modifications that Schema Synchronization will perform on the objects of the target schema.

     
  7. Open the Deployment Script tab and view and analyze the deployment script.

     
  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.

  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. 

See Also


  • No labels