Progress
DataServer
for ORACLE Guide
Migrating a Progress Database to ORACLE with PRO/SQL
The PRO/SQL utility creates a SQL script (.sql file) that contains all the data definition statements needed to re-create a Progress database as an ORACLE database. The script contains statements to define only those features that are supported by ORACLE. For example, if your Progress database has word indexing, the SQL script does not include an equivalent index definition because ORACLE does not support this feature.
The script does, however, attempt to mimic some basic Progress functionality that would not otherwise be available in an ORACLE database. The script creates a PROGRESS_RECID column to support Progress record identifiers, a shadow column for each case-insensitive indexed column, and a column for each extent of an array.
PRO/SQL is not integrated into the DataServer architecture. Unlike the Progress-to-ORACLE migration utility, it does not create a schema holder for you. If you want to access the ORACLE database that you create using the PRO/SQL .sql file, you must create a schema holder for it.
See the Progress Basic Development Tools manual or online help for instructions on using PRO/SQL.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |