SQL Anywhere® Server - Database Administration  > 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 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.