A publication is a database object that identifies the data that is to be synchronized. It defines the data to be uploaded, and it limits the tables that can be downloaded to. (The download is defined in the download_cursor script.)
A publication consists of one or more articles. Each article specifies a subset of a table that is to be synchronized. The subset may be the entire table or a subset of its rows and/or columns. Each article in a publication must refer to a different table.
You create a subscription to link a publication to a user.
You create publications using Sybase Central or with the CREATE PUBLICATION statement.
In Sybase Central, all publications and articles appear in the Publications folder.
By default, trigger actions in a SQL Anywhere client are not synchronized to the MobiLink server, on the assumption that the same triggers exist in the back end database to which the data is synchronized. For more information about this behavior, see SendTriggers (st) extended option.
Publishing a whole table
Publishing only some columns in a table
Creating a publication using a WHERE clause
Modifying the properties of existing publications or articles
Modifying an existing publication using SQL
Dropping a publication
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|