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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » SQL Anywhere database connections » SQL Anywhere for Windows Mobile » Windows Mobile database configuration » Windows Mobile database creation


Creating a Windows Mobile database (Sybase Central)

Sybase Central enforces the requirements for Windows Mobile databases when creating them and gives you the option of copying the database file to your device.


If you want the Create Database Wizard to automatically copy a new database to your Windows Mobile device, then Sybase Central must be the same bitness as ActiveSync or Windows Mobile Device Center (32-bit or 64-bit). For Windows XP and earlier, only 32-bit software is supported.

  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 uses Windows Mobile Device Center (ActiveSync) to transfer the database to the Windows Mobile device.

  3. In Sybase Central, click Tools » SQL Anywhere 16 » 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. Click Create This Database For Windows Mobile and then click Next.

  7. Click 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.


    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.


    Store a copy of your key in a safe location. You need the specify the key each time you to start or modify the database. A lost key results in an inaccessible database, from which there is no recovery.

  13. Select a page size and click Next.

  14. On the Specify Additional Settings page, click 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 (dbicu16.dll and dbicudt16.dat) are not required by the database server. Click 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:

    Tap Start » 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.


You can start the Windows Mobile database on the device.

 See also