Release 10.1A: OpenEdge Data Management:
DataServer for ORACLE

> ## Adjust an ORACLE schema image to an OpenEdge database

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

> | To run the Adjust Schema utility:

> 1. Connect to the source Progress database.

> 2. Connect to the Schema Image Schema Holder.

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

> 4. Interface element | Description
>    --- | ---
>    Original Progress DB | Enter the name of the source OpenEdge 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 semicolons must separate the groups. The groups are table, sequence, and view, and must be listed in that order.

>    Provide the information as described in the following table:

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