SQL Anywhere® Server - Database Administration  > Replicating Data with Replication Server  > Tutorial: Replicate data using Replication Server  > Lesson 9: Set up Replication Server

Create a connection for the replicate site

Using isql, connect to Replication Server and create a connection to the replicate site SQL Anywhere database.

The following command creates a connection to the repdb database on the REPDB Open Server.

CREATE CONNECTION TO REPDB.repdb
SET ERROR CLASS rs_sqlserver_error_class
SET FUNCTION STRING CLASS rs_sqlserver_function_class
SET USERNAME dbmaint
SET PASSWORD dbmaint
go

This statement differs from the primary site server statement in that there is no WITH LOG TRANSFER ON clause in this statement.

If you have changed the dbmaint user ID and password in the rssetup.sql command file, make sure you replace the dbmaint username and password in this command.