Publications in UltraLite

Publications define a set of articles that describe the data to be synchronized. Each article 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) if you want 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.

Maximum user publications

The maximum number of user publications in UltraLite is 63.

Adding publications

You can add publications to an UltraLite database with Sybase Central, or using SQL. For UltraLite synchronization, each article in a publication may include either a complete table, or may include a WHERE clause.

Notes

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.

To publish data from an UltraLite database (Sybase Central)

Connect to the UltraLite database using the UltraLite plug-in.
Right-click the Publications folder and choose New » Publication.
Enter a name for the new publication. Click Next.
On the Tables tab, select a table from the Matching Tables list. Click Add.

The table appears in the Selected Tables list on the right.
Add additional tables.
If necessary, click the Where tab to specify the rows to be included in the publication. You cannot specify column subsets.
Click Finish.

To publish data from an UltraLite database (SQL)