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 tables and publications to the remote UltraLite database	For UltraLite 9, you can use the ulinit command line utiltiy to create a remote database using the schema from a consolidated SQL Anywhere database. Alternatively, you can start the UltraLite Schema Painter from the PocketBuilder Database painter, select File>New> UltraLite Schema, type a name with a USM extension for the schema, and click OK. Then you can 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 optionally, publications. For UltraLite 10 you can create the database based on the schema of the consolidated database using the Create Synchronization Model wizard of the MobiLink plug-in to Sybase Central. You can also create an empty database and add tables to it using the UltraLite plug-in to Sybase Central..
Add 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. The above description is for the Admin mode of the MobiLink 10 plug-in to Sybase Central 5.0. This is the only mode available for MobiLink 9. For MobiLink 10, you can use the plug-in Mode menu to switch between Admin and Model modes. Automatic 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.
For UltraLite 9, generate the UltraLite schema as a remote UltraLite database	Start the Create UltraLite 9.x Database utility in PocketBuilder, browse to a USM file you created with the UltraLite 9 Schema Painter, enter a name for a new UltraLite database, and click the OK button.

Table 17-1: Preparing databases for MobiLink synchronization

Preparation step

How to do this

Add tables and publications to the remote UltraLite database

For UltraLite 9, you can use the ulinit command line utiltiy to create a remote database using the schema from a consolidated SQL Anywhere database. Alternatively, you can start the UltraLite Schema Painter from the PocketBuilder Database painter, select File>New> UltraLite Schema, type a name with a USM extension for the schema, and click OK. Then you can 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 optionally, publications.

For UltraLite 10 you can create the database based on the schema of the consolidated database using the Create Synchronization Model wizard of the MobiLink plug-in to Sybase Central. You can also create an empty database and add tables to it using the UltraLite plug-in to Sybase Central..

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

The above description is for the Admin mode of the MobiLink 10 plug-in to Sybase Central 5.0. This is the only mode available for MobiLink 9. For MobiLink 10, you can use the plug-in Mode menu to switch between Admin and Model modes.

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

For UltraLite 9, generate the UltraLite schema as a remote UltraLite database

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