Tutorial: Running Windows Mobile databases from Sybase Central

Sybase Central is a database management tool that provides a graphical user interface for administering SQL Anywhere. Sybase Central can also be used for managing other products, including MobiLink synchronization.

Once you complete this tutorial, you will be able to perform key tasks associated with the database server: starting and stopping the server, running single and multiple databases on a database server, and connecting to a database.

Requirements
Before you begin

You need to create two Windows Mobile databases for use in the tutorial.

To create databases for your Windows Mobile device
  1. Connect your Windows Mobile device to the computer.

  2. Choose Start » Programs » SQL Anywhere 11 » Sybase Central.

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

  4. Follow the instructions in the Create Database Wizard.

  5. On the Specify A Database page, click Browse and select a location for the database file. Name the database file Alpha.

  6. On the Choose To Create For Windows Mobile page, click Create This Database For Windows Mobile and then click Next.

    The wizard tests the connection to your Windows Mobile device.

  7. On the Choose To Copy The Database page, select Copy The Database To Your Windows Mobile Device.

  8. In the Windows Mobile File Name field, type \My Documents\Alpha.db.

  9. Select Delete The Desktop Database After Copying and then click Next.

  10. On the Specify A Collation Sequence For NCHAR Data page, select Use The Following Supplied Collation, and then select UTF8BIN.

    For more information, see Installation considerations: Using ICU on Windows Mobile.

  11. Click Finish.

  12. Click Close.

  13. Repeat this procedure and create a database called \My Documents\Beta.db.


Lesson 1: Start the database server
Lesson 2: Start multiple databases on the Windows Mobile database server
Lesson 3: Shut down the database server on Windows Mobile