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

SQL Anywhere 11.0.0 » UltraLite - Database Management and Reference » Using UltraLite Databases » Creating and configuring UltraLite databases » Creating UltraLite databases


UltraLite on-device creation

You can program your application to create a new UltraLite database if one cannot be detected at connection time. The application can then use SQL to create tables, indexes, foreign keys, and so on. Populating the database is then simply a question of synchronizing with a consolidated database.


This option is not as ideal as other available database creation options: by adding all the additional database creation and SQL code, your application size can grow considerably. Nonetheless, this option can simplify deployment because you only need to deploy the application to the device. Additionally, in some pre-production development cycles, you may want to delete and reconstruct the database on your device for testing purposes.

See also