The simplest publication you can make consists of a set of articles, each of which contains all the rows and columns in one table. These tables must already exist.
Connect to the remote database as a user with DBA authority, using the SQL Anywhere plug-in.
Open the Publications folder.
Choose File » New » Publication.
In the What Do You Want To Name The New Publication field, enter a name for the new publication. Click Next.
On the Available Tables list, select a table. Click Add.
Connect to the remote database as a user with DBA authority.
Execute a CREATE PUBLICATION statement that specifies the name of the new publication and the table you want to publish.
The following statement creates a publication that publishes the whole customer table:
CREATE PUBLICATION pub_customer ( TABLE customer )
The following statement creates a publication including all columns and rows in each of a set of tables from the SQL Anywhere sample database:
CREATE PUBLICATION sales ( TABLE customer, TABLE sales_order, TABLE sales_order_items, TABLE product )
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|