skip to main content
OpenEdge Data Management: DataServer for ODBC
The DataServer Tutorial : Migrating an OpenEdge database to an ODBC data source
 

Migrating an OpenEdge database to an ODBC data source

The DataServer for ODBC supports the OpenEdge DB-to-ODBC utility that allows you to migrate an OpenEdge database to an ODBC data source. While the DataServer typically makes an ODBC data source conform to an OpenEdge database, this utility provides compatibility in the opposite direction. It copies an existing OpenEdge database schema into a target ODBC data source.
The OpenEdge DB-to-ODBC utility performs the following tasks:
*Creates objects in the target ODBC data source
*Creates the schema holder and schema image
*Optionally populates the ODBC data source by dumping and loading the data from the OpenEdge database
The ODBC data source that you create with this utility is a basis for an application database. Before deploying your new ODBC data source, you might want to make manual adjustments to take advantage of additional ODBC-compliant features that are not supported by the migration utility.
The OpenEdge DB-to-ODBC utility requires a local OpenEdge database.
In this section: 
* Preparing a data source for the utility
* Running the OpenEdge DB-to-ODBC utility
* Running the utility interactively