Managing server attributes

In OpenEdge Release 11, the DataServer for Microsoft SQL Server is enhanced to enable you to define foreign RDBMS constraint definitions within the meta schema of your OpenEdge database for use in migrating your database to a foreign data source. Once migrated to the foreign data source, constraint definitions can be pulled back into your OpenEdge schema holder.

To achieve this, OpenEdge provides a submenu for the MS SQL Server Utilities for creating constraint definitions. The following figure shows the Server Attributes submenu.

Figure 1. Server Attributes submenu


From the Server Attributes submenu, you can access dialog boxes that provide an interface to create, view, and maintain server attributes, and define constraint definitions applied to the data and indexes of the foreign database within your OpenEdge schema holder. The dialog boxes accessed from the Server Attributes submenu are as follows:

  • View/Maintain Foreign constraint definitions — Use the View/Maintain Foreign Constraint Definitions dialog box, shown in the figure below, to define and delete constraint definitions as well as view constraint definition properties.

    Figure 2. View/Maintain Foreign Constraint Definitions dialog box


See Defining constraint definitions in Data Administration for details on how to define constraint definitions. See Modifying an existing constraint definition for details on how to maintain constraint definitions.

  • Activate/Deactivate constraint definitions — Use the Activate/Deactivate Constraint Definitions dialog box, shown in the following figure, to activate or deactivate constraint definitions you defined.

    Figure 3. Activate/Deactivate Constraint Definitions dialog box


    See Activating or deactivating a class of existing constraint definitions for details on how to activate and deactivate constraint definitions.

  • Delete constraint definitions — Use the Delete Constraint Definitions dialog box, shown in the following figure, to delete defined constraint definitions.

    Figure 4. Delete Constraint Definitions dialog box


    See Deleting one existing constraint definition for details on how to delete constraint definitions.

  • Generate constraint definitions from ROWID — Use the Generate Constraints from ROWID dialog box, shown in the following figure, to generate constraint definitions in an OpenEdge database from the ROWID designations that exist in the schema image of a connected schema holder database.

    Figure 5. Generate Constraint from ROWID dialog box