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.

Prerequisites

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.

Results

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

Next

You can start the database.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0