Contents Index Create a connection for the replicate site. Configure and start the Adaptive Server Anywhere LTM

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

Create a replication definition

Using isql, connect to Replication Server and create a replication definition. The following statement creates a replication definition for the news table on the primedb database:

create replication definition news
with primary at PRIMEDB.primedb
( id int, author char(40), text char(255) )
primary key ( id, author )
go

For a full description of the CREATE REPLICATION DEFINITION statement, see your Replication Server Reference Manual.

If you set the qualify_table_owner option to on in the LTM configuration file, you must specify the table owner in the statement, for all replicating tables.


Contents Index Create a connection for the replicate site. Configure and start the Adaptive Server Anywhere LTM