Versions Compared

Old Version 1

changes.mady.by.user Nadine Hinojosa

Saved on

compared with

New Version 2

changes.mady.by.user Wara Hermosa

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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. 

Table of Contents
excludeSee Also

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

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

    StateDescription
    Image AddedObjects exist in both schemas and are identical.
    Image AddedObjects exist in both schemas but are different.
    Image AddedObjects exist in the AQUA_DEVELOPMENT schema but not in the AQUA_TEST schema.
    Image AddedObjects exist in the AQUA_TEST schema but not in the AQUA_DEVELOPMENT schema.
  2. From Image Added state, click an object to view its DDL script differences in the SQL Differences pane.
    Image Added
  3. Right-click anywhere in the upper pane and then click Synchronize All Items. 
    Image Added

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.
    Image Added
     
  2. In the Map Missing Columns tab, map the target column with the source column, and click Next.
    Image Added
     
  3. In the Configure Script tab, choose an appropriate action for each issue, and click Next.
    Image Added
     
  4. In the Options tab, ensure that you select the appropriate options, and click Next.
    Image Added
     
  5. In the Warnings tab, review the warnings that Schema Synchronization encountered while generating the deployment script.
    Image 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 Added
     
  7. Open the Deployment Script tab and view and analyze the deployment script.
    Image Added
     
  8. After you have reviewed the deployment script, click Open Script in Query Analyzer > click Image Added > execute the deployment script.

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

    Image Added
  9. Open the Schema Compare Results tab, click Image Added 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 Added

See Also