Primary database connectivity for SQL Anywhere

By default, the SQL Anywhere Replication Agent uses the sa user ID and password created by the rssetup.sql command file to log in to the SQL Anywhere primary database.

Create the user ID and password that the SQL Anywhere Replication Agent uses to log in to the primary Replication Server. Record these values in the rs_user and rs_pw configuration parameters in the SQL Anywhere Replication Agent configuration file. The user ID must have been defined and granted connect source permission in the primary Replication Server.

A Replication Server database connection name is made up of two parts: a data server name (server_name) and a database name (db_name). Record these values in the RS_source_ds and RS_source_db configuration parameters in the SQL Anywhere Replication Agent configuration file.

The primary Replication Server does not use the source_db portion of the Replication Server database connection. Instead, Replication Server obtains the database name from the command line of the data server identified in the source_ds portion of the Replication Server database connection. However, you must include a database name in the Replication Server create connection statement to conform to the syntax.