Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
The DataServer Tutorial : Migrating an OpenEdge database to MS SQL Server
 

Migrating an OpenEdge database to MS SQL Server

The DataServer for MS SQL Server supports the OpenEdge DB to MS SQL Server utility that allows you to migrate an OpenEdge database to a foreign data source through the use of the MS SQL Server DataServer. While the DataServer makes a 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 data source.
The OpenEdge DB to MS SQL Server utility performs the following tasks:
*Creates objects in the target data source
*Creates the schema holder and schema image
*Optionally populates the data source by dumping and loading the data from the OpenEdge database
The MS SQL Server data source that you create with this utility is a basis for an application database. Before deploying your new data source, you might want to make manual adjustments to take advantage of additional MS SQL Server features that are not supported by the migration utility.
The OpenEdge DB to MS SQL Server utility requires a local OpenEdge database.
* Preparing a data source for the utility
* Migrating defined constraint definitions to your foreign data source
* Running the OpenEdge DB to MS SQL Server utility