The following procedure describes how to define a unique key constraint definition. Alternately, you can define unique 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. Select DataServer > MS SQL Server Utilities > Server Attributes > View/Maintain Foreign Constraints.

    The View/Maintain Foreign Constraint Definitions 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 Definitions for tablename dialog box appears, as shown in figure below.

  4. Select UNIQUE from Constraint Type.

    The Create Foreign Constraint Definitions for tablename for a unique key dialog box, appears as shown in the following figure.

    Figure 1. Create Foreign Constraint Definitions for tablename dialog box for unique constraint definitions


  5. Accept the 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 selected. Leave this box selected 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.
  10. Click Create to save the constraint definition and remain in the dialog box to define more constraint definitions for the selected table.