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 » Creating an UltraLite database

 

Create an UltraLite database from the command prompt

Use the ulcreate utility to create a database from a command prompt. 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