Progress
DataServer
for ORACLE Guide


Adjust ORACLE Schema Image to Progress Database

The Adjust Schema utility allows you to migrate schema changes from an ORACLE database and compare it to the same schema in a Progress database. If you make changes in both your Progress database and the same changes in ORACLE using ORACLE tools, pull those changes into the schema holder. The Adjust Schema utility will compare the Progress database to the schema image and update the Progress attributes necessary for your 4GL code to run against both data sources.

Follow these steps to run the Adjust Schema Utility:

  1. From the DataServer menu in either the Data Administration tool or the Character Data Dictionary choose DataServers ORACLE Utilities Schema Migration Tools Adjust Schema.
  2. The following dialog box appears:

  3. Provide the information as described in Table 5–14.
  4. Table 5–14: Adjust Schema Utility Progress-to-ORACLE Utility
    Interface Element
    Description
    Original Progress DB
    Enter the name of the source Progress database
    Schema Image
    Enter the ORACLE database logical name. The logical database name is the name of the schema image.
    Files to Compare
    Either leave the default **all** for all objects to be compared or enter the names of tables, sequences, or Progress Views to be compared. If listing individual objects, the list must be a comma-separated list within a group of objects and semi-colons must separate the groups.

  5. Connect to the source Progress database.
  6. Connect to the Schema Image Schema Holder.
  7. Select Adjust Schema option from the Oracle Utilities Schema Migration menu.
  8. Verify that the proper names are displayed in the Original Progress DB and Schema Image fields.
  9. Either leave the **all** to compare all objects or type the names of objects to be compared as follows:
  10.      <table>,<table>,....;<sequence>,<sequence>,....;<view>,<view>,.... 
    

  11. Select OK to start the utility.

Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095