Publishing data in UltraLite

Add publications to an UltraLite database using SQL Central or SQL.

Context

Publications define a set of articles that describe the data to be synchronized.

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.

Note 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.

Procedure

Connect to the UltraLite database using the UltraLite plug-in.
Right-click the Publications folder and click New Publication .
Enter a name for the new publication. Click Next.
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.
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.

Results

The new publication is created.