Replicate database connectivity for SQL Anywhere

You do not need to use a database gateway when you use SQL Anywhere as a replicate data server; the replicate Replication Server connects directly to the SQL Anywhere replicate data 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). The replicate Replication Server looks for an interface file entry for the replicate database server_name specified in the database connection.

Replication Server logs in to the replicate data server using the user_name and password specified in the database connection. For SQL Anywhere replicate databases, the user_name and password should be the dbmaint user ID and password that were created when the rssetup connection profile was executed.

The replicate 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.

You also must make an entry in the Replication Server interface file to identify the host and port where the SQL Anywhere replicate data server is listening. The interface file entry name must match the server_name portion of the Replication Server database connection.