SQL Anywhere® Server - Database Administration  > SQL Anywhere for Windows CE  > Using the administration utilities on Windows CE

Tutorial: Running Windows CE 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.

• Complete all the tasks in the following sections before you begin the tutorial:

  • SQL Anywhere for Windows CE
  • Connecting to a database running on a Windows CE device
  • Creating an ODBC data source to connect to your Windows CE device

• Connect your Windows CE device to a computer.

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

To create databases for your Windows CE device

1. Ensure that your Windows CE device is connected to the computer.

2. Open Sybase Central on your computer by choosing Start > Programs > SQL Anywhere 10 > Sybase Central.

   Sybase Central appears.

3. Start the Create Database wizard by choosing Tools > SQL Anywhere 10 > Create Database.

   The Create Database wizard appears.

4. Name the database Alpha.db. Click Next.

   You can disregard the directory that the database is stored in on the computer because the computer copy will be deleted once the database is copied to your Windows CE device.

5. Select the Create This Database for Windows CE option. Click Next.

   The wizard tests the connection to your Windows CE device.

6. Select the Copy the Database to Your Windows CE Device option.

   Copy the database to the My Documents directory on your Windows CE device by typing the following in the Windows CE File Name field: \My Documents\Alpha.db. Click Next.

7. Select the Delete the Desktop Database After Copying option.

8. Follow the remaining instructions in the wizard.

9. Click Finish to create the database with the default settings.

   Once the wizard finishes copying the Alpha.db database file to your Windows CE device, continue to the next step.

10. 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 CE device, you are ready to begin the tutorial.

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