Create Database Connections

A connection defines a database to the Replication Server. A Replication Server is designated to manage the database and, if it is a replicate database, to distribute transactions to the database.

The database connection provides Replication Server with:

The name of the data server and database the connection is for
The error class used to process errors returned from the data server
The function-string class to use with the database
The maintenance user login name and password
Information about whether there is a RepAgent thread for the database connection
Options for creating active and standby databases for warm standby applications
Configuration parameters that affect connections

To create:

A standard connection to an Adaptive Server database, use Sybase Central, rs_init, or create connection.
Alternate connections to an Adaptive Server database, use create alternate connection. For example, you can create alternate connections to build multiple replication paths. See:
- Replication Server Reference Manual > Replication Server Commands > create alternate connection
- Replication Server Administration Guide Volume 2 > Performance Tuning > Multi-Path Replication
Connection to a non-Sybase database, use create connection with the using profile clause. See Replication Server Reference Manual > Replication Server Commands > create connection using profile.

Information Required to Add a Database Connection
You need to specify several items when you add a database connection.
Use the create connection Command
To add a database for a non-ASE data server, use the create connection command with a connection profile specific to your non-ASE data server. To add a database for an Adaptive Server data server, you use Sybase Central or rs_init, both of which prepare the database for replication.

Parent topic: Manage Database Connections