Irrespective of the database creation method you employ, you must always configure the database properties that control and/or define characteristics of the database when you create a database. You do not need to configure any database properties if you are comfortable with the defaults values. However, once the database has been created, you cannot re-configure these values. If you need to change any database property, you must re-create the database.
You can categorize database creation methods into two categories:
Desktop creation methods with UltraLite administration tools designed for this purpose. This chapter will primarily focus on these methods.
On-device creation methods with UltraLite APIs. On-device creation methods are primarily described in each API specific UltraLite programming guide. These methods are briefly described here for reasons of completeness only.
Once the database is created, you can connect to it and build the tables and other database objects you need.
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, you should create a database in Sybase Central with the Create Database wizard for UltraLite. This wizard handles the file compatibility logic for you, which prevents you from creating a file that is not supported on your combination of deployment devices.
UltraLite desktop creation
UltraLite on-device creation