Progress
DataServer
for ORACLE Guide


Preparing a Database for the Utility

The Progress-to-ORACLE utility does not literally translate definitions for Progress fields into ORACLE columns. It makes some adjustments in order to provide the functionality of the Progress and ORACLE systems. Table 5–5 describes the changes to a database that result from making a Progress database compatible with ORACLE by selecting the Create Extended 4GL Objects option when using the Progress-to-ORACLE utility.

Table 5–5: A Progress-to-ORACLE Database Conversion
Progress Database
ORACLE Database
Record ID
An additional NUMBER column named PROGRESS_RECID
Case-insensitive index
An additional column named U##field
Array
A column for each array element named field##1, field##2, etc.
Sequence
A sequence with the same characteristics (incrementation, beginning value, etc.)

The utility makes these changes in the target ORACLE database automatically. The following sections explain how to account for these changes when you plan your migration.


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