Creating a new empty OpenEdge database

The DataServer uses the empty OpenEdge database as a holder for the schema for your MS SQL Server database. The simplest way to create an empty OpenEdge database is to do it from the Data Administration, as described in this section. For information on other ways to create an empty OpenEdge database, see OpenEdge Data Management: Database Administration.

If you create a new OpenEdge application to be Unicode-enabled, ensure that you create the database from a Unicode source. A copy of the empty OpenEdge UTF-8 database can be obtained from $DLC/prolang/utf/empty. If you choose UTF-8 as your schema image code page, your schema holder's code page must also be UTF-8. If you create a new OpenEdge application to be Unicode-enabled, ensure that you create the database from a Unicode source. A copy of the empty OpenEdge UTF-8 database can be obtained from $DLC/prolang/utf/empty. If you choose UTF-8 as your schema image code page, your schema holder's code page must also be UTF-8.

To create and connect an empty OpenEdge database from the OpenEdge Data Administration tool:

  1. Start the Data Administration tool.
  2. Select the Database > Create option.

    The following dialog box appears:



  3. Type the schema-holder name (for example, mssholder) in the New Physical Database Name field.
  4. Select the An EMPTY Database option.
  5. Choose OK.

    The following dialog box appears. By default, the name of the newly created data source appears in the Physical Name field, as shown:



    You do not have to provide any additional connection information. You can add connection parameters when you create the data source or edit connection information later. See the online help for a complete description of the Connect Database dialog box.

  6. Choose OK to connect the empty OpenEdge database and return to the Data Administration main window.