ASA Database Administration Guide
Replicating Data with Replication Server
Tutorial: Replicate data using Replication Server
Lesson 9: Set up Replication Server
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.