The OpenEdge DataServer for Oracle supports the OpenEdge DB-to-Oracle utility that allows you to migrate an OpenEdge database to an Oracle database. While the DataServer typically makes an Oracle database conform to an OpenEdge database, this utility provides compatibility in the opposite direction. It copies an existing OpenEdge database schema into a target Oracle database. The utility performs the following tasks:

• Creates objects in the target Oracle database
• Creates the schema holder and schema image
• Optionally populates the Oracle database by dumping and loading the data from the OpenEdge database

The Oracle database you create with this utility is a basis for an application database. Before deploying your new Oracle database, you might want to make manual adjustments to take advantage of additional Oracle features that are not supported by the migration utility, such as clustering and multiple tablespaces.

The OpenEdge-to-Oracle utility has the following requirements:

• A local OpenEdge database
• Oracle permissions, as identified in the following table

sys.argument$
sys.cclol$
sys.cdef$
sys.col$
sys.com$
sys.con$
sys.dual
sys.icol$
sys.ind$
sys.link$
sys.obj$
sys.procedure$
sys.seq$
sys.syn$
sys.tab$
sys.ts$
sys.user$
sys.view$