Default and Alternate Connections

In multipath replication, connections include the default and one or more alternate connections.

A connection that accepts data from a Replication Agent is a primary connection, and a connection that applies data to a database is replicate connection. A default or alternate connection can be a primary or replicate connection.

The default connection is the one that you create from a Replication Server to a specific primary or replicate database when you add the database to the replication domain. You can use rs_init, the Replication Manager Sybase Central plug-in, create connection, or create connection ... using profile to create the default connection depending on whether the data server is Adaptive Server or a supported non-ASE data server.

The default connection uses the data server and database names in the form of dataserver.database as the connection name, where dataserver and database are the actual data server and database names, respectively.

You can create multiple alternate connections after you create the default connection, which is required. Each alternate connection must have a unique name.

After you create an alternate connection, you can alter the connection properties or drop the connection. You can also display the status of all connections and create subscriptions for the connection.

When you create an alternate connection, the user ID must be a valid user. When you create connections to Sybase IQ replicate databases, you must specify the connection profile and connection profile version, and a unique maintenance user name for the default connection and each alternate connection .