Create a Windows Mobile database using Sybase Central

Sybase Central has features to make database creation easy for Windows Mobile. Sybase Central enforces the requirements for Windows Mobile databases, and gives you the option of copying the database file to your device.

 To create a Windows Mobile database in Sybase Central and copy it directly to your Windows Mobile device
  1. Connect your Windows Mobile device to your desktop computer.

  2. Start Sybase Central on your desktop computer. For the 32-bit version of Windows Mobile Device Center (ActiveSync), you must start the 32-bit version of Sybase Central. Sybase Central will use Windows Mobile Device Center (ActiveSync) to transfer the database to the Windows Mobile device.

  3. Choose Tools » SQL Anywhere 12 » Create Database.

  4. Click Create A Database On This Computer. Click Next.

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

  6. Select Create This Database For Windows Mobile and then click Next.

  7. Select Copy The Database To Your Windows Mobile Device and then click Next.

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

    Tip

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

    When starting a database on your Windows Mobile device using the Server Startup Options window, 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 window.

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

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

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

    On your Windows Mobile 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.

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

  11. Clear the Install jConnect Metadata Support option and then click Next.

  12. Set the level of encryption for your database by selecting the appropriate option and then 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.

    Caution

    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.

  13. Select a page size and click Next.

  14. On the Specify Additional Settings page, select Include Checksum With Each Database Page and then click Next.

  15. Follow the remaining instructions in the wizard and then click Finish to create the database and copy it to your device.

    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 (dbicu12.dll and dbicudt12.dll) are not required by the database server. Select Use The Following Supplied Collation, and then select UTF8BIN.

  16. A window appears, tracking the progress of the files being copied to your Windows Mobile device. Click Close.

  17. Once the wizard has copied the database to your Windows Mobile device, verify the location of the files:

    From the Start menu, tap Programs » File Explorer and navigate to the Windows Mobile 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 Mobile device.