Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » UltraLite - Database Management and Developer Guide » UltraLite as a MobiLink client » UltraLite clients

UltraLite publications

A publication is a database object that identifies the data that is to be synchronized.

To synchronize all tables and all rows of those tables in your UltraLite database, do not create any publications.

A publication consists of a set of articles. Each article may be an entire table, or may be rows in a table. You can define this set of rows with a WHERE clause.

Each database can have multiple publications, depending on the desired synchronization logic. For example, you may want to create a publication for high-priority data. The user can synchronize this data over high-speed wireless networks. Because wireless networks can have usage costs associated with them, you would want to limit these usage fees to those that are business-critical only. All other less time-sensitive data could be synchronized from a cradle at a later time.

You create publications using SQL Central or with the CREATE PUBLICATION statement. In SQL Central, all publications and articles appear in the Publications folder.

Usage notes
  • UltraLite publications do not support the definition of column subsets, nor the SUBSCRIBE BY clause. If columns in an UltraLite table do not exactly match tables in a SQL Anywhere consolidated database, use MobiLink scripts to resolve those differences.

  • Columns are always sent in the order in which they were defined in the CREATE TABLE statement.

  • You do not need to set a table synchronization order in a publication. If table order is important for your deployment, you can set the table order when you synchronize the UltraLite database by setting the Table Order synchronization parameter.

  • Because object ownership is not supported in UltraLite, any user can delete a publication.