Consultor Eletrônico

Status: Verified

GOAL:

How to migrate an ORACLE database to a Progress database?

GOAL:

Is there an automated process to migrate an ORACLE db to a Progress db?

GOAL:

What things do I have to consider when migrating an ORACLE db to a Progress db?

FIX:

Unfortunately, there is no automated utility (utilities) to migrate an ORACLE db to a Progress db. The only way to convert from ORACLE to Progress is to dump the definitions from the existing schema holder/schema image and load it into an empty Progress database.

However, the only problem is that the definition dump file (.df) file generated from the schema holder/schema image must be changed before loading it into the Progress database. This change involves KEYWORD difference between a Progress db and Progress DataServer. There are some keywords in the .df file that apply only to the DataServer which do not apply to a Progress db. These keywords need to be removed from the .df file before they are uploaded into the Progress db. Examples of KEYWORDS are i.e., DSRV, FOREIGN, MISC or SHADOW.

The following is a list of the keywords the must get deleted from the .df
file (delete the whole line). If these keywords are not deleted from the .df before the loading, the load process might hang and fail.

For table/field definition, the keywords that must be delete are:

Step 1:
FOREIGN-NAME
FOREIGN-TYPE
PROGRESS-RECID
FILE-MISC12
INDEX-FREE-FLD
RECID-FLD-NAME
FOREIGN-POS
FOREIGN-NAME
FOREIGN-TYPE
DSRVR-PRECISION
DSRVR-SCALE
DSRVR-LENGTH
DSRVR-FLDMISC
SHADOW-COL
QUOTED-NAME
MISC-PROPERTIES
SHADOW-NAME

Step 2:
For sequence definition are:

FOREIGN-NAME
FOREIGN-OWNER
SEQ-MISC3

Step 3:
For index definition, delete the keywords:

INDEX-NUM
FOREIGN-NAME
RECID-INDEX

Step 4:
If you have specific tables, then delete the 'TYPE ORACLE ' phrase from the ADD TABLE syntax

If you have all tables, then delete ADD DATABASE paragraph and replace with UPDATE DATABASE "?"