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

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » Creating and Configuring UltraLite Databases » Creating UltraLite databases » UltraLite desktop creation

Creating an UltraLite database from Sybase Central Next Page

Creating an UltraLite database from the command prompt

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

To create a new UltraLite database (command prompt)
  1. Open a command prompt.

  2. Run the ulcreate utility, including any necessary parameters.

    For example, to create a case-sensitive UTF-8 database called test.udb, such that it overwrites a database if it already exists, run the command with the following syntax:

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

    Notice that supplying a database file in a connection string is simply an alternative to specifying the database file after the other command prompt options. For example:

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