PowerDesigner includes all of the resources you need to generate a set of data definition language (DDL) statements in a SQL script directly from the data model. You can run this script to generate a schema for your ASE database. The ASE database schema must match the Sybase IQ schema, as Sybase IQ is the Replication Server target database in Risk Analytics.
The process of using PowerDesigner to create the DDL scripts for ASE is the same as creating the script for Sybase IQ. Follow the steps in “Creating the schema for the Sybase IQ database” with the following differences for Adaptive Server Enterprise:
Change the default Risk Analytics owner RAP_USER to the name of the Adaptive Server Enterprise database owner.
In the Change the Target DBMS dialog, choose Sybase AS Enterprise 12.5.2 as the target database.
Generate the DDL as described in the section “Producing DDL from the data model in PowerDesigner”.
Follow the instructions in the next section to execute the DDL script on your Adaptive Server Enterprise database. Do not execute the DDL script as described in “Executing the DDL script”, as this procedure is for Sybase IQ only.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
