UltraLite Database User's Guide
Synchronization for UltraLite Applications
Designing synchronization for your UltraLite database
Designing sets of data to synchronize separately
Publications can be added to the UltraLite database using the schema painter, the ULXML utility, or from a reference database.
To publish data from an UltraLite database (Schema Painter)
Connect to the UltraLite database.
In the left pane, open the Synchronization folder.
Double-click Add Publication.
Specify a set of tables to include in the publication.
Click OK to save the changes.
For UltraLite synchronization, each article in a publication may include either a complete table or may include a WHERE clause.
To publish data from an UltraLite reference database (Sybase Central)
Connect to the database as a user with DBA authority.
Open the Publications folder and double-click Add Publication.
Type a name for the new publication. Click Next.
On the Tables tab, select a table from the list of Matching Tables. Click Add. The table appears in the list of Selected Tables on the right.
Add additional tables as required. The order of the tables is not important.
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 reference database (SQL)
Connect to the database as a user with DBA authority.
Execute a CREATE PUBLICATION statement that specifies the name of the new publication and the table you want to publish.
For more information, see CREATE PUBLICATION statement.