The following procedure describes how to define a unique key constraint definition. Alternately, you can define unique key constraint definitions during migration.

To define a unique key constraint definition:

  1. Start Data Administration and connect to the OpenEdge database you are migrating.
  2. SelectDataServer > ORACLE Utilities > Server Attributes > View/Maintain Foreign Constraints. The View/Maintain Foreign Constraints dialog box appears.
  3. Select the table for which you are defining a unique key constraint definition and click Create Constraints. The Create Foreign Constraint Definition for tablename dialog box appears, as shown in figure below.
  4. Select UNIQUE from Constraint Type. The appearance of the Create Foreign Constraint Definition for tablename dialog box is modified as shown in the following figure .
    Figure 1. Create Foreign Constraint Definition for tablename dialog box for unique constraint definition


  5. Accept the generated default constraint definition name, or enter a new one.
  6. Select an index for the unique key constraint definition.
  7. By default, the unique key constraint definition has the Active check box checked. Leave this box checked if you want the constraint definition you are defining to be available for migration.
  8. Optionally, add a description of the constraint definition in the Description box.
  9. Click OK to save the constraint definition and exit the dialog box. Click Create to save the constraint definition and remain in the dialog box to define more constraint definitions for the selected table.