You can create a database from a command prompt with the ulcreate utility. With this utility, you can include utility options to configure the database.

To create a new UltraLite database (command prompt)

Run the ulcreate utility, including any necessary options. For example, to create a case-sensitive UTF-8 database called test.udb, overwriting the database if it already exists, run the following command:

ulcreate -c "DBF=test.udb" -o "case=respect;utf_encoding=1" -y

Supplying a database file in a connection string is an alternative to specifying the database file after the other options. For example:

ulcreate -o "case=respect;utf_encoding=1" -y test.udb

See also

• Creating an UltraLite database from Sybase Central
• Creating an UltraLite database from a SQL Anywhere reference database
• Creating an UltraLite database from XML
• UltraLite Create Database utility (ulcreate)
• Choosing database creation parameters for UltraLite
• Upgrading UltraLite