Contents Index Preparing a reference database Setting database options in the reference database pdf/preface.pdf

UltraLite User's Guide
  Developing UltraLite Applications
    Preparing a reference database

Creating a reference database

The analyzer uses the reference database as a template when constructing your UltraLite application.

To create a reference database

  1. Start with an existing Adaptive Server Anywhere database or create a new database using the dbinit command.

    For more information on upgrading a database, see Using an existing database as a reference database.

  2. Add the tables and foreign key relationships that you need within your application. You can use any convenient tool, such as Sybase Central or Sybase PowerDesigner Physical Architect (included with SQL Anywhere Studio), or a more powerful database design tool such as the complete Sybase PowerDesigner package.

Performance tip 
You do not need to include any data in your reference database. However, if you populate your database tables with data representative of the data you expect to be stored by a typical user of your application, the UltraLite analyzer automatically uses this data to optimize the performance of your application.

For information about designing a database and creating a schema, see Designing Your Database.

Example 

  1. Create a database.

    From a command prompt, execute the following statement:

    dbinit path\dbname.db

  2. Use Sybase Central to add tables for your UltraLite application, based on your own needs.

  3. Add your sample data. Interactive SQL includes an Import menu item that allows several common file formats to be imported.

    For more information, see Importing data.

Contents Index Preparing a reference database Setting database options in the reference database pdf/preface.pdf