Creating a schema holder

The MS SQL Server Utilities are located under the DataServer menu option in the Data Administration. Progress Software Corporation recommends that you use the Create DataServer Schema option to pull in all the objects that your application needs. This will create the schema information as a database type of MS SQL Server instead of ODBC. After completing the schema pull, the schema needs to be adjusted to conform to OpenEdge behavior.

Use the following steps to adjust the schema after completing the pull:

  1. Connect to the original OpenEdge database.
  2. Select the DataServer > MS SQL Server Utilities > Schema Migration Tools > Adjust Schema option to fix the OpenEdge attributes needed for your application to run. You can specify the entire schema holder or specific objects.