Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » 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 Next Page

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 Replication Server Reference Manual.

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