Kbase P31134: How to migrate a Progress Database to an ORACLE Database using DataServer?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
GOAL:
How to migrate a Progress Database to an ORACLE Database using DataServer?
GOAL:
Which DataServer tool can migrate a Progress db to an ORACLE db?
GOAL:
Progress to ORACLE migration
FACT(s) (Environment):
Oracle DataServer
FIX:
The DataServer for ORACLE supports the Progress-to-ORACLE utility that allows you to migrate a Progress database to an ORACLE database. While the DataServer typically makes an ORACLE database conform to a Progress database, this utility provides compatibility in the opposite direction. It copies an existing Progress database schema into a target ORACLE database. The utility performs the following tasks:
1. Creates objects in the target ORACLE database
2. Creates the schema holder and schema image
3. Optionally populates the ORACLE database by dumping and loading the data from the Progress database
The ORACLE database you create with this utility is a basis for an application database. Before deploying your new ORACLE database, you might want to make manual adjustments to take advantage of additional ORACLE features that are not supported by the migration utility, such as clustering and multiple tablespaces.
For complete steps on how to migrate, refer to section 'The Progress-to-ORACLE Utility' within chapter The DataServer Tutorial in The Progress DataServer for ORACLE Guide.