Generating a new ESP Schema Model from a Sybase IQ or ASE Model

Generate a new 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 Generate new Logical Data Model.
4. Specify a Name.
   Code is autogenerated from the name.
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 Extensions tab, choose ESPSchema.
7. On the Selection tab, choose tables from which to generate schema.
8. Choose OK.