The simplest publication you can make consists of a set of articles, each of which contains all the rows and columns in one table.
The tables to be published must already exist.
Context and remarks
A publication can also be created by executing a CREATE PUBLICATION statement that specifies the name of the new publication and the table you want to publish.
Connect to the remote database as a user with DBA authority, using the SQL Anywhere 12 plug-in.
Open the Publications folder.
Click 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.
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.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|