Generating Database Schema with PowerDesigner

PowerDesigner includes all the resources you need to generate a set of DDL statements in SQL scripts directly from the PowerDesigner data models. Run these scripts to generate a schema for your SAP Sybase IQ, SAP HANA, and ASE databases.

1. In PowerDesigner, open the data model.
2. Change the default database user.
3. Generate the script that creates a schema for the new database.
4. Log in to the database and run the script.

• Changing the Default Database User
  Overwrite the default database owner for the SAP Sybase IQ, SAP HANA, or ASE database with a name specific to your environment.