Data Modeling Scenarios

Integrated modeling supports efficient schema definition and database design, and consistent production deployments.

Using the ESP Schema and extensions, you can:

Model schema in the ESP Schema model, a PowerDesigner logical data model
Convert an ESP Schema logical data model to ASE or Sybase IQ physical data models
Convert existing ASE and Sybase IQ physical data models to an ESP Schema logical data model
Import schema definitions defined in a CCL file into an ESP Schema model
Export schema definitions from an ESP Schema model into a CCL file
Validate a model using custom checks for ESP Schema, in addition to the standard PowerDesigner checks
Analyze the impact of changes to schema, a model, or a database table on all components in the integrated model

The ASE database schema must match the Sybase IQ database schema for all tables in which data will be inserted. After you make changes, you can use PowerDesigner to produce a set of data definition language (DDL) statements directly from the physical data model. PowerDesigner saves the DDL in a SQL script that you can run to generate the tables and other objects for the target databases.

DDL generation does not require use of the extended modeling feature.