Updating an existing ESP Schema Model from a Sybase IQ or ASE Model

Update an existing ESP Schema logical data model from either Sybase IQ or ASE physical data models.

  1. Open either the Sybase IQ or ASE model.
  2. From the PowerDesigner main menu, choose Tools > Generate Logical Data Model.
  3. In the General tab of the LDM Generation Options dialog, choose Update existing Logical Data Model.
  4. Select the model and leave Preserve Modifications selected.
  5. On the Detail tab, choose Options:
    • (Optional) Check model
    • (Optional) Save generation dependencies
    • (Optional) Convert names into codes
    • (Required) Enable transformations
  6. On the Selection tab, choose tables from which to generate schema.
  7. Choose OK.