Generate either a Sybase IQ or a ASE physical data model from an ESP
Schema logical data model.
- Open the ESPSchema model.
- From the PowerDesigner main menu, choose .
- In the General tab of the PDM Generation Options dialog,
choose Generate new Physical Data Model.
- 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. |
- Click the Detail tab.
- (Optional) Choose Check model and Save generation dependencies.
- Ensure that Enable transformations is selected.
- 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
- On the Pre-generation and Post-generation tabs, ensure that all transformation rules are selected.
The post-generation tab appears only for new models.
- On the Selection tab, select
ESPSchema to create tables for Sybase IQ or ASE, and choose
OK.
Next
After generation, check indexes, set physical options, and add foreign keys as needed.