This procedure tells you how to define the Sybase IQ <target database> as the target connection and the ASE source as a primary and target connection. You must perform this procedure twice—once for the target Sybase IQ <target database> and once for the ASE database.
Replication Server communicates directly with all the data servers by using Open Client connectivity. Replication Server database connections are configured as either replicate-only, or primary-and-replicate (bidirectional) in a Sybase-only replication system.
Click Rep Server | Connections | Add Database Connection. The Add Database Connection Wizard starts.
Choose the server name and database for the new connection. Click Next.
Enter the user name and password for the maintenance user. Click Next.
Identify the connection type. Choose one of these options, then click Next.
Replicate Only (use this option for Sybase IQ)
Primary and Replicate (use this option for ASE)
Review the wizard summary. If all options are correct, click Next.
Repeat these steps until you define the Sybase IQ <target database> and the ASE database.
The maintenance user in the connection definition must match the user defined in Sybase IQ <target database>. For example, if you create a maintenance user called ruser, you must create a maintenance user called ruser as part of the connection definition.
The maintenance user for the ASE connection must differ from the IQ maintenance user for replication to work properly.
See “Troubleshooting” for information on problems that you may encounter after creating the IQ connection.
