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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » SQL Anywhere for Windows CE » Configuring Windows CE databases » Creating a Windows CE database

Creating a Windows CE database using Sybase Central Next Page

Creating a Windows CE database using dbinit


The Initialization utility (dbinit) can be used to create databases that can be used on Windows CE. However, you cannot copy them directly to a Windows CE device from this utility. You must manually copy databases created with the dbinit utility to your Windows CE device.

Enable checksums for Windows CE databases

When creating a database that will be deployed to Windows CE, you should enable checksums. This helps to provide early detection if the database file becomes corrupt.

To create a database using the dbinit utility
  1. At a command prompt on your computer, navigate to the directory where you want to create your database.

    For example:

    cd temp
  2. Create your database by entering the following command:

    dbinit -s database-name.db

    The -s option enables checksums for the database.

    Tip

    You can also configure database properties such as encryption and page size using the Initialization utility. See Initialization utility (dbinit).

  3. Copy the database to your Windows CE device.

    For more about copying the database to your Windows CE device, see Copying a database to your Windows CE device.