Preparing to use the wizard for remote ASA databases  UltraLite synchronization sample

Chapter 17: Using MobiLink Synchronization

Preparing to use the wizard for remote UltraLite databases

Before you use the UltraLite Synchronization wizard in a production application, you need to complete the tasks listed in Table 17-1.

Table 17-1: Preparing databases for MobiLink synchronization

Preparation step

How to do this

Add publications to the consolidated database

Connect to the consolidated database using an ASA connection in Sybase Central, select the Publications node, and click the New Publication toolbar button.

Add tables and publications to the remote UltraLite database

Start the UltraLite Schema Painter and select File>New>UltraLite Schema, type a name with a USM extension for the schema, and click OK. Alternatively select the Tables and Synchronization nodes under the new schema and click the items in the right pane of the painter to add tables and publications.

Create MobiLink users, script versions, and synchronized tables in the consolidated database

Connect to the consolidated database using a MobiLink Synchronization connection in Sybase Central, add new users under the Users node, add script versions under the Versions node, add tables under the Synchronized Tables node, then add scripts for each synchronized table by selecting each table sequentially and clicking Add Table Script in the right pane. The table script associates a script version with a scripting event for each table.

NoteAutomatic addition of users and scripts Adding users and script versions is optional for non-production databases, because you can add these automatically using special selections in the wizard or by modifying objects created by the wizard.

Generate the UltraLite schema as a remote UltraLite database

Start the Create UltraLite Database utility in PocketBuilder, browse to a USM file you created with the UltraLite Schema Painter, enter a name for a new UltraLite database, and click the OK button.





Copyright © 2004. Sybase Inc. All rights reserved. UltraLite synchronization sample

View this book as PDF