UltraLite User's Guide
  Developing UltraLite Applications
    Designing your UltraLite database
      Designing sets of data to synchronize separately

Creating publications for UltraLite databases

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)

1. Connect to the database as a user with DBA authority.

2. Open the Publications folder and double-click Add Publication.

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

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

5. Add additional tables as required. The order of the tables is not important.

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

7. Click Finish.

To publish data from an UltraLite reference database (SQL)

1. Connect to the database as a user with DBA authority.

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