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

Generate either a Sybase IQ or a ASE physical data model from an ESP Schema logical data model.

1. Open the ESPSchema 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 Generate new Physical Data Model.
4. For a new model, choose the target DBMS and the appropriate Name and Code.
   • For ASE, choose:

     Field	Value
     DBMS	Sybase Adaptive Server Enterprise 15.7
     Name	Keep the default, ESPSchema_1 (the name of the container), or enter another name.
     Code	Auto-generated from Name. For example, when Name is ESPSchema_1, Code is ESPSCHEMA_1.

   • For Sybase IQ, choose:

     Field	Value
     DBMS	Sybase IQ 15.X Note: Use latest version of Sybase IQ available.
     Name	Keep the default, ESPSchema_1 (the name of the container), or enter another name.
     Code	Auto-generated from Name. For example, when Name is ESPSchema_1, Code is ESPSCHEMA_1.

5. Click the Detail tab.
6. (Optional) Choose Check model and Save generation dependencies.
7. Ensure that Enable transformations is selected.
8. Click the Extensions tab and ensure that the appropriate extension is selected:
   • ASE when generating a new Adaptive Server Enterprise model
   • IQ when generating a new Sybase IQ model
9. On the Pre-generation and Post-generation tabs, ensure that all transformation rules are selected.
   The post-generation tab appears only for new models.
10. On the Selection tab, select ESPSchema to create tables for Sybase IQ or ASE, and choose OK.

After generation, check indexes, set physical options, and add foreign keys as needed.

• Checking Indexes
  PowerDesigner creates default indexes. Add, edit, or remove them as needed.
• Setting Physical Options
  Set physical options for each table as needed for your Sybase IQ or ASE database.
• Adding Foreign Keys
  Add foreign-key relationships to physical data models.