Publications in UltraLite

Publications define a set of articles that describe the data to be synchronized. In general, 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 the _nosync table suffix approach and allow you to have more granular control. 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.

Adding publications

You can add publications to the UltraLite database with Sybase Central, or from Interactive SQL. For UltraLite synchronization, each article in a publication may include either a complete table, or may include a WHERE clause (except with HotSync on Palm OS).

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.

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 Add 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. If you are using HotSync synchronization, do not specify a WHERE clause.
Click Finish.

To publish data from an UltraLite database (Interactive SQL)

Connect to the UltraLite database.
Execute a CREATE PUBLICATION statement that specifies the name of the new publication and the tables you want to publish.