CustDB (Customer Database) helps you learn about various aspects of UltraLite as part of a multi-tiered database management solution that includes MobiLink synchronization with a SQL Anywhere consolidated database. The desktop-based tutorials in this chapter use CustDB examples to demonstrate features and behaviors of UltraLite.
CustDB is a simple example of point-of-sale customer management solution that consists of the following:
A consolidated SQL Anywhere database. This data is pre-populated with sales-status data.
A remote UltraLite database. This database is initially empty.
An UltraLite client application.
A MobiLink server synchronization sample with synchronization scripts already created for you.
While different versions of the application code exists for each supported programming interface and platform, subsequent tutorials reference the compiled version of the application for Windows desktops only. It is important to remember that each version implements UltraLite features with some variation to conform to the conventions of each platform.
CustDB allows sales personnel to track and monitor transactions and then pool information from two types of users:
Sales personnel that authenticate with user IDs 51, 52, and 53.
Mobile managers that authenticate with user ID 50.
Information gathered by these different users can be synchronized with the consolidated database.
After following each lessons you will know how to:
Run the MobiLink server to carry out data synchronization between the consolidated database and the UltraLite remote.
Use Sybase Central to browse the data in the UltraLite remote.
Manage UltraLite databases with UltraLite command line utilities.