Updating an existing Sybase IQ, SAP HANA, or ASE Model from an ESP Schema Model

Update either an SAP Sybase IQ, SAP HANA, or a ASE physical data model from a ESP Schema logical data model.

  1. Open the ESP Schema model.
  2. From the PowerDesigner main menu, choose Tools > Generate Physical Data Model.
  3. In the General tab of the PDM Generation Options dialog, choose Update existing Physical Data Model.
  4. Select the model and leave Preserve Modifications selected.
  5. Click the Detail tab.
  6. (Optional) Choose Check model and Save generation dependencies.
  7. Ensure that Enable transformations is selected.
  8. In the Merge Models dialog, confirm the updates you want and choose OK.
Next
After generation, check indexes, set physical options, and add foreign keys as needed.