An empty OpenEdge Database is created to act as the schema holder for the MSS DataServer. The schema holder is the layer that allows ABL to interact with the MS SQL Server Database as though it were a native OpenEdge Database.

Perform the following steps to create a schema holder:

  1. In the Proenv window, type prodb sportssh empty to create an empty schema holder database.
  2. Now start a single user session by typing prowin sportssh -1. The Procedure Editor window appears.
  3. From the Procedure Editor, select Tools > Data Administration.
  4. Select DataServer > MS SQL Server Utilities > Create DataServer Schema . The Create/Modify Record for MSS Schema window appears.
  5. Specify Logical Database name as sportssql, ODBC Data Source Name as sportsodbc. Click Ok.
  6. Enter the Login ID and Password if required in the next dialog box and click OK.
  7. Enter criteria for Object Name, Object Owner (typically, but not always “DBO”), and Qualifier.
  8. Select the Default to OpenEdge DATETIME option.
  9. If you are using LOB fields in replication, ensure that the Default to OpenEdge LOB for BLOBs option is selected along with the CLOBs option. This forces the data server to automatically consider certain target side data types to be treated as LOBS.

    By selecting CLOB, varchar(max)/nvarchar(max) data types are automatically converted to CLOB. By selecting BLOB the data server is forced to consider all varbinary(max) as BLOB. On source fields that are character types, Pro2 may convert some types to varchar(max) when the source width is wider than the MAX_CHAR_WIDTH property setting. This conversion has the added benefit of avoiding row size limits for SQL Servers. However, varchar(max)/nvarchar(max) are not necessarily treated as CLOBS.



  10. Click OK to finish.