Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
The DataServer Tutorial : Managing server attributes : Activating or deactivating a class of existing constraint definitions
 

Activating or deactivating a class of existing constraint definitions

Once you have defined constraint definitions, you can activate or deactivate a whole class of constraint definitions at once. When a constraint definition is deactivated, it is unidentified and disabled during a subsequent migration.
The following steps demonstrate how to activate or deactivate a class of constraint definitions.
To activate a class of constraint definitions:
1. Start Data Administration and connect to the OpenEdge database you are migrating.
2. Select DataServer > MS SQL Server Utilities > Server Attributes > Activate/Deactivate Constraints.
The Activate/Deactivate Constraint Definitions dialog box appears, as shown in the following figure.
Figure 23. Activate/Deactivate Constraint Definitions dialog box
3. Chose the Activate or Deactivate toggle.
4. Select a constraint definition type or ALL.
5. Click OK to activate or deactivate constraint definitions and exit the dialog box, or click Cancel to exit without changing the state of the constraint definitions.