Contents Index Designing sets of data to synchronize separately Synchronizing high-priority changes

UltraLite Database User's Guide
   Synchronization for UltraLite Applications
    Designing synchronization for your UltraLite database
      Designing sets of data to synchronize separately

Creating publications for UltraLite databases

Components 

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)

  1. Connect to the UltraLite database.

  2. In the left pane, open the Synchronization folder.

  3. Double-click Add Publication.

  4. Specify a set of tables to include in the publication.

  5. Click OK to save the changes.

Reference database 

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.


Contents Index Designing sets of data to synchronize separately Synchronizing high-priority changes