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( 128 ), 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.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |