UltraLite ActiveX User's Guide
  Tutorial: An UltraLite Application for Pocket IE

Lesson 3: Create and deploy an UltraLite database schema

The database schema is a description of the database. It describes the tables, indexes, keys, and publications within the database, and all the relationships between them.

A database schema may be created using the UltraLite Schema Painter or the ulinit utility. The following procedure uses ulinit to create a database schema based on an Adaptive Server Anywhere database.

To create the database schema

1. Create a directory on your computer for this tutorial.

   The remainder of the tutorial assumes that this directory is c:\tutorial\pie. If you create a directory with a different name, use that directory instead of c:\tutorial\pie throughout the tutorial.

2. Copy the contents of the Samples\UltraLiteActiveX\pie subdirectory of your SQL Anywhere 9 installation to c:\tutorial\pie.

3. Create the consolidated database.

   Open a command prompt and navigate to c:\tutorial\pie. Run the following command:

   dbinit custdbsrv.db

4. Start the MobiLink synchronization server.

   Run the following command:

   runml.bat

5. Create the UltraLite schema using the ulinit utility.

   For more information about the ulinit utility, see UltraLite initialization utility.

   Run the following command:

   makeschemas.bat

To deploy the database schema to your device

1. Start the File Viewer.

   From eMbedded Visual Basic 3.0, choose Tools > Remote Tools > File Viewer.

2. The File Viewer connects to your device.

   • Choose Connection > Add New Connection.

   • Open the folder corresponding to your device type.

   • Select your device.

3. Choose File > New Folder. Create a folder named UltraLiteDB.

4. Choose File > Export File.

5. Browse to c:\tutorial\pie\ul_custdb.usm. Click Open to export the file to your device.