Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
The DataServer Tutorial : Managing server attributes
 

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 12. 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 13. 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 14. Activate/Deactivate Constraint Definitions dialog box
See Activating or deactivating a class of existing constraintdefinitions 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 15. 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 16. Generate Constraint from ROWID dialog box
* Overview of foreign database constraint definitions
* Constraint definition names
* Defining constraint definitions in Data Administration
* Defining a primary key constraint definition
* Defining a unique key constraint definition
* Defining a foreign key constraint definition
* Defining a check constraint definition
* Defining a default constraint definition
* Modifying an existing constraint definition
* Activating or deactivating a class of existing constraint definitions
* Deleting contstraint definitions
* Generating constraint definitions from ROWID