This is the consolidated database. During installation, an ODBC data source called SQL Anywhere 12 CustDB is created for this database. The database file is located at %SQLANYSAMP12%\UltraLite\CustDB\. You can recreate this database at any time using makedbs.cmd (makedbs.sh for Mac or Linux).

You can erase changes that were synchronized into the consolidated CustDB.db file, so you have a clean version to work with using this script: C:\Program Files\SQL Anywhere 12\UltraLite\CustDB\newdb.bat

For more information about the schema of this file, see CustDB sample for MobiLink.

This is the remote version of the consolidated database that contains only a subset of the information, depending on which user synchronizes the database.

The file name and location can vary depending on the platform, programming language, or even device.

The UltraLite database is also recreated by the makedbs.cmd script (makedbs.sh for Mac or Linux).

The SQL scripts that rebuild a CustDB consolidated database for any one of the supported RDBMSs.

In the C:\Program Files\SQL Anywhere 12\MobiLink\CustDB directory, you can find the following files:

• For SQL Anywhere: custdb.sql
• For Adaptive Server Enterprise: custase.sql
• For Microsoft SQL Server: custmss.sql
• For Oracle: custora.sql
• For IBM DB2: custdb2.sql
• For MySQL: custmys.sql

For more information about setting up a consolidated database, see Setting up the CustDB consolidated database.

These are the end-user applications that provide a user-friendly interface to the UltraLite remote database. There is a sample client installed for each supported platform.

Each client application also contains a ReadMe.html or ReadMe.txt file. Although the contents of these files vary, they all include an outline the steps required to build and run the sample.

The location the applications and its ReadMe depends on your development environment. See Lesson 1: Building and running the CustDB application.

The UltraLite database SQL statements and synchronization calls are located in custdbcpp.cpp for the C++ API and in custdb.sql for ESQL.

• MobiLink consolidated databases