Contents Index Lesson 9: Set up Replication Server Create a connection for the replicate site.

ASA Database Administration Guide
  Replicating Data with Replication Server
    Tutorial: Replicate data using Replication Server
      Lesson 9: Set up Replication Server

Create a connection for the primary site

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

The following command creates a connection to the primedb database on the PRIMEDB Open Server.

create connection to PRIMEDB.primedb
set error class rs_sqlserver_error_class
set function string class rs_sqlserver_function_class
set username dbmaint
set password dbmaint
with log transfer on
go

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.

Replication Server does not actually use the primedb database name; instead, the database name is read from the command line of the PRIMEDB Open Server. You must, however, include a database name in the CREATE CONNECTION statement to conform to the syntax.

For a full description of the create connection statement, see the chapter "Replication Server Commands" in the Replication Server Reference Manual.


Contents Index Lesson 9: Set up Replication Server Create a connection for the replicate site.