Generating Database Schema with PowerDesigner

PowerDesigner includes all the resources you need to generate a set of data definition language (DDL) statements in SQL scripts directly from the RAP- The Trading Edition data models. Run these scripts to generate a schema for your RAPStore and RAPCache databases.

Prerequisites 

Install Sybase PowerDesigner on Windows before you generate DDL for the RAP databases.

See “Installing PowerDesigner” in “Installing RAP - The Trading Edition” of the RAP - The Trading Edition Installation and Configuration Guide.

For information on using PowerDesigner, see the PowerDesigner product documentation.

To generate DDL from a data model:

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

Parent topic: Generating DDL Scripts

Created October 8, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com