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 (SQL)

Create a database on your desktop computer and then copy the file onto your Windows Mobile device.

Prérequis

Your ability to execute the CREATE DATABASE statement depends on the setting for the -gu option, and whether you have the SERVER OPERATOR system privilege.

 Task
  1. In Interactive SQL, connect to a database. You must be connected to a database to create another database. For example, connect to the utility database.

  2. Type the following statement in the SQL Statements pane of Interactive SQL, where database-name is the name of the new database:

    CREATE DATABASE 'c:\\temp\\database-name.db'
    DBA USER 'DBA' DBA PASSWORD 'sql'
    TRANSACTION LOG ON
    CHECKSUM ON;
  3. From the SQL menu, click Execute.

    A database and transaction log are created in the c:\temp directory of your computer.

  4. Copy the database file to your Windows Mobile device.

Résultat

A database is created and copied to your Windows Mobile device.

Suivant

You can start the database.

 See also