Release 10.1A: OpenEdge Data Management:
DataServer for ORACLE

> ## 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 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 OpenEdge Development: Basic Development Tools or online Help for instructions on using PRO/SQL.

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