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

SAP Sybase SQL Anywhere 16.0 » UltraLite - Database Management and Reference » UltraLite as a MobiLink client » UltraLite clients » UltraLite client synchronization design


Publishing data in UltraLite

Publications define a set of articles that describe the data to be synchronized. You can add publications to an UltraLite database using Sybase Central or SQL.


There are no prerequisites for this task.

Contexte et remarques

Publication articles can be a whole table, or can define a subset of the data in a table. You can include an optional predicate (a WHERE clause) to define a subset of rows from a given table. Publications are more flexible than creating tables with SYNCHRONIZE OFF. To synchronize data subsets of an UltraLite database separately, use multiple publications. You can then combine publications with upload-only or download-only synchronization parameters to synchronize high-priority changes efficiently.


The maximum number of user publications in UltraLite is 63.

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

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.

  1. Connect to the UltraLite database using the UltraLite plug-in.

  2. Right-click the Publications folder and click New » Publication.

  3. Enter a name for the new publication. Click Next.

  4. On the Tables tab, click a table in the Matching Tables list. Click Add.

    The table appears in the Selected Tables list on the right.

  5. Add additional tables.

  6. If necessary, click the Where tab to specify the rows to be included in the publication. You cannot specify column subsets.

  7. Click Finish.


The new publication is created.

 See also