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

  11. Click Close.

  12. Repeat Steps 3 through 9 to create a database called Beta.db.

    The path in Step 6 for the second database is \My Documents\Beta.db.

Once the wizard finishes copying the Beta.db database file to your Windows Mobile device, you are ready to begin the tutorial.


Lesson 1: Starting the database server
Lesson 2: Starting multiple databases on the Windows Mobile database server
Lesson 3: Shutting down the database server on Windows Mobile