MobiLink Synchronization User's Guide
Adaptive Server Anywhere Clients
A publication is a database object that identifies the data that is to be synchronized. A publication consists of articles, which are subsets of a table's columns, rows, or both. Each publication can contain one or more entire tables, or partial tables consisting of selected rows and columns. In a single publication, no table can be included in more than one article.
You create publications using Sybase Central or with the CREATE PUBLICATION statement.
In Sybase Central, all publications and articles appear in the Publications folder.
DBA authority is required to create and drop publications.
A single publication can publish a subset of columns from a set of tables and use a WHERE clause to select a set of rows to be replicated.
Views and stored procedures cannot be included in publications.
Publications and subscriptions are also used by the Sybase message-based replication technology, SQL Remote. SQL Remote requires publications and subscriptions in both the consolidated and remote databases. In contrast, MobiLink publications appear only in Adaptive Server Anywhere remote databases. MobiLink consolidated databases are configured using synchronization scripts.
Publishing whole tables
Publishing only some columns in a table
Publishing only some rows in a table
Altering existing publications
Dropping publications