Generating Scripts for Replication to IQ

To generate the RepServer definition and Sybase ASE staging database, you need to generate the RepServer definition, the Sybase ASE staging database, and the Sybase IQ database.

  1. Right click the Replication Server process symbol and select Generate Scripts. Click the Tasks tab and select the Execute generated scripts in Replication Server task.

    The Replication Server creation script is generated and executed using ISQL.

  2. Click OK in the Generation dialog box.
  3. Right-click the Sybase ASE staging database symbol and select Generate Database. Specify any appropriate database generation options and click OK to start generation.
  4. Right-click the Sybase IQ database symbol and select Generate Database or Modify Database. Specify any appropriate database generation or modification options and click OK to start generation.
Parent topic: Modeling Replications to an SAP® Sybase® IQ Data Warehouse