Kbase P93613: How do I migrate schema changes from Progress to Oracle?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/05/2006 |
|
Status: Unverified
GOAL:
How do I migrate schema changes from Progress to Oracle?
GOAL:
Is there a Progress-to-ORACLE Incremental Schema Migration Utility?
GOAL:
What is delta SQL progress to oracle utility?
FACT(s) (Environment):
Oracle DataServer
FIX:
The Incremental Schema Migration utility (delta SQL Progress to Oracle) allows you to migrate schema changes from Progress to an ORACLE database.
The utility reads a Progress delta.df file that has been created using the standard incremental dump procedure and creates a delta.sql file that contains the SQL DDL for making the changes and a delta.df file. You can then load the delta.df file into the schema holder. You can then apply the delta.sql file to the ORACLE instance to complete the migration process.
Note that you do not make schema changes directly in the schema holder, which must remain synchronized with the ORACLE database. The utility uses the schema holder to determine what the ORACLE definitions are.