Chapter 12 Working with Replication Server

Generating the RepServer definition and the staging tables in Sybase IQ

To generate the RepServer definition and the staging tables in Sybase IQ, you need to generate the RepServer definition and generate or modify the Sybase IQ database.

To generate the RepServer definition:

1. Right-click the RepServer process symbol and select the Generate Scripts command in the contextual menu. For an existing RepServer, you need to regenerate because the connection and function strings are changed.
   
   The Generation dialog box is displayed.
2. Click the Tasks tab and select the Execute generated scripts in Replication Server task.
3. Click OK, the RepServer creation script is generated and executed using ISQL.

To generate or modify the Sybase IQ:

1. Right-click the Sybase IQ database symbol and select the Generate Database or Modify Database commands in the contextual menu.
   
   The Database Generation or Database Modification dialog box is displayed.
2. Define database generation/modification options and click OK to start generation.

Copyright (C) 2007. Sybase Inc. All rights reserved.