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.