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 steps you use to create a script for ASE are the same as those for Sybase IQ. Follow the steps in “Generating DDL Scripts” in the Risk Analytics User’s Guide 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 “Generating DDL Scripts” in the Risk Analytics User’s Guide, but do not select Create index in the Indexes panel on the Keys & Indexes tab.
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 “Generating a DDL Script” as this procedure is for Sybase IQ only.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
