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:
- 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:
![]()
- Provide the information as described in Table 5–14.
- Connect to the source Progress database.
- Connect to the Schema Image Schema Holder.
- Select Adjust Schema option from the Oracle Utilities Schema Migration menu.
- Verify that the proper names are displayed in the Original Progress DB and Schema Image fields.
- Either leave the **all** to compare all objects or type the names of objects to be compared as follows:
- Select OK to start the utility.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |