Migrating an OpenEdge Database to Oracle with PRO/SQL

The PRO/SQL utility creates an SQL script (.sql file) that contains all the data definition statements needed to re-create an OpenEdge database as an Oracle database. The script contains statements to define only those features that are supported by Oracle. For example, if your OpenEdge 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 OpenEdge functionality that would not otherwise be available in an Oracle database. The script creates a PROGRESS_RECID column to support Progress record identifiers, initial values, and a column for each extent of an array.

PRO/SQL is not integrated into the DataServer architecture. Unlike the OpenEdge-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 OpenEdge Development: Basic Development Tools or online Help for instructions for using PRO/SQL.