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

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » Working with UltraLite Databases

Dropping an index Next Page

Working with UltraLite publications


A publication is a database object that identifies a subset of UltraLite data you want to synchronize with the MobiLink server at one time. If you wish 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 selected rows from a table. You can define this set of rows with a WHERE clause (except with HotSync on Palm OS).

Each database can have multiple publications, depending on the synchronization logic you require. 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 Sybase Central or with the CREATE PUBLICATION statement. In Sybase Central, all publications and articles appear in the Publications folder.

Usage notes
See also

Publishing whole UltraLite tables
Publishing a subset of rows from an UltraLite table
Dropping a publication for UltraLite