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 Next Page

Creating a Windows CE database using Sybase Central

Sybase Central has features to make database creation easy for Windows CE. If you have Windows CE services installed on your Windows computer, you can create a Windows CE database using Sybase Central. Sybase Central enforces the requirements for Windows CE databases, and gives you the option of copying the database file 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 Windows CE database in Sybase Central and copy it directly to your Windows CE device
  1. Ensure your Windows CE device is connected to your computer.

  2. Start Sybase Central on your computer: from the Start menu, choose Programs > SQL Anywhere 10 > Sybase Central.

  3. Start the Create Database wizard: from the Tools menu, choose SQL Anywhere 10 > Create Database.

    The Create Database wizard appears.

  4. Choose Create a Database on This Computer, and then click Next.

    The database is initialized on the computer before it is copied to the Windows CE device.

  5. Specify a file name and directory to store the database file in on your computer, and then click Next.

  6. Select Create This Database for Windows CE, and then click Next.

    This option ensures that the new database conforms to the settings required to run the database on Windows CE.

    When you click Next, Sybase Central attempts to connect to your Windows CE device.

  7. Select Copy the Database to Your Windows CE Device to have Sybase Central automatically copy the database to your device once it is initialized. Click Next.

  8. Specify the Windows CE directory to copy your database files to. The default location is the main device directory.


    Copy the database to the My Documents directory of your Windows CE device to make it simpler to start the database.

    When starting a database on your Windows CE device using the Server Startup Options dialog, you can only use Browse to search for the database file in the My Documents directory.

    If the database is not stored in the My Documents directory, you must type the path of the database in the Database field of the Server Startup Options dialog.

    Optionally, you can select the Delete the Desktop Database After Copying option.

    If you choose not to delete the computer copy, a copy of the database file is stored on your computer in the directory that you specified in Step 5. Click Next.

  9. On the Specify a Collation Sequence for NCHAR Data page, select the collation for NCHAR data for your database. If you are not using character set conversion and do not require the ICU library, select UTF8BIN.

  10. Specify the directory where you want to save the transaction log file. Click Next.

    On your Windows CE device, the transaction log file is created in the same directory as the database file when the database is started on the network database server for the first time.

  11. Specify whether you want to use a transaction log mirror. Click Next.

    A mirror log can help in data recovery should the transaction log become corrupt. However, it is not necessary.

  12. Ensure the Install jConnect Meta-information Support option is not selected. Click Next.

  13. Set the level of encryption for your database by selecting the appropriate option. Click Next.

    If you select strong encryption, you must specify an encryption key. It is recommended that you choose a value for your key that is at least 16 characters long, contains a mix of upper and lowercase, and includes numbers, letters, and special characters.


    Be sure to store a copy of your key in a safe location. You require the key each time you want to start or modify the database. A lost key will result in a completely inaccessible database, from which there is no recovery.

  14. Ensure that the Include Checksum With Each Database Page option is selected. You can select the other options on this page as required for your database. Click Next.

    Follow the remaining instructions in the wizard.

  15. Click Finish to create the database and copy it to your device.

    A dialog appears, tracking the progress of the files being copied to your Windows CE device.

  16. Once the wizard has copied the database to your Windows CE device, you can verify the location of the files.

    From the Start menu, tap Programs > File Explorer and navigate to the Windows CE directory that you copied the database to.

    The database file is listed there. The transaction log file does not appear until the first time you start the database on your Windows CE device.