Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » UltraLite - Database Management and Reference » Using UltraLite Databases


Creating and configuring UltraLite databases

There are two types of database creation methods:

  • Desktop creation methods with UltraLite administration tools designed for this purpose.

  • On-device creation methods with UltraLite APIs. On-device creation methods are primarily described in each API specific UltraLite programming book.

Once the database is created, you can connect to it and build tables and other database objects.


If you do not want to use default values, you must set the creation parameter values when creating a database. The values cannot be changed after the database is created. If you need to change any database property, you must re-create the database, specifying a different value for the creation parameter.

Sharing a database among multiple platforms

Within the configuration differences imposed by different operating systems, you might be able to copy the database from one device to another. If you are unsure of property compatibility among multiple platforms, create a database in Sybase Central with the UltraLite Create Database Wizard. This wizard handles the file compatibility logic for you. In so doing, it prevents you from creating a file that is not supported on your combination of deployment devices.

See also

Creating an UltraLite database
Choosing database creation parameters for UltraLite
UltraLite character sets
Securing UltraLite databases