Publishing whole tables

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.

♦ To publish one or more entire tables (Sybase Central)

Connect to the remote database as a user with DBA authority, using the SQL Anywhere 12 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.
Click Next.
On the Available Tables list, select a table. Click Add.
Click Finish.

♦ To publish one or more entire tables (SQL)

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.

See CREATE PUBLICATION statement [MobiLink] [SQL Remote].

Example

The following statement creates a publication that publishes the whole Customers table:

CREATE PUBLICATION pub_customer (
 TABLE Customers
)

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 Customers,
 TABLE SalesOrders,
 TABLE SalesOrderItems,
 TABLE Products
)

Discuter à propos de cette page dans DocCommentXchange.