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

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » Working with database files » Creating a database

 

Creating databases (Sybase Central)

You can create a database in Sybase Central using the Create Database Wizard. See Creating databases (SQL), and Creating databases (command line).

To create a new database (Sybase Central)

  1. Start Sybase Central.

  2. Choose Tools » SQL Anywhere 11 » Create Database.

    The Create Database Wizard appears.

  3. Follow the instructions in the wizard.

Tip

You can also access the Create Database Wizard from within Sybase Central using the following methods:

  • Selecting a server, and choosing File » Create Database.
  • Right-clicking a server, and choosing Create Database.
Creating databases for Windows Mobile
Note

If you do not install the ICU libraries when you install SQL Anywhere on Windows Mobile, then using only the default settings in the Create Database Wizard, results in a database that cannot run on Windows Mobile. For information about creating databases for Windows Mobile, see Installation considerations: Using ICU on Windows Mobile, and Creating a Windows Mobile database.

You can create databases for Windows Mobile by copying a SQL Anywhere database file to the device.

Sybase Central has features to make database creation easy for Windows Mobile databases. If you have Windows Mobile services installed on your Windows desktop, you have the option to create a Windows Mobile database when you create a database from Sybase Central. Sybase Central omits some features for Windows Mobile databases, and optionally copies the resulting database file to your Windows Mobile device.

When you run a database on Windows Mobile, the database server automatically enables checksums to help provide early detection if the database file becomes corrupt. See Using checksums.

Specify a collation sequence for NCHAR data

If NCHAR UCA sorting is not required, the NCHAR collation sequence should be UTF8BIN. In this way, the ICU libraries (dbicu11.dll, dbicudt11.dll) are not required by the database server. Select Use The Following Supplied Collation, and then select UTF8BIN.