Create a Windows Mobile database using the CREATE DATABASE statement

The CREATE DATABASE statement can be used to create databases in Interactive SQL on your desktop computer. However, you cannot copy them directly to a Windows Mobile device from this application. You must manually copy databases to your Windows Mobile device.

To create a database using the CREATE DATABASE statement

Choose Start » Programs » SQL Anywhere 12 » Administration Tools » Interactive SQL.

If the Connect window does not appear automatically, choose SQL » Connect.
Click the Identification tab and complete the following fields:
- User ID Type DBA.
- Password Type sql.
- Action Select Connect With An ODBC Datasource.
- ODBC Data Source Name Click Browse, choose the MobileServer data source that you created in Create an ODBC data source to connect to your Windows Mobile device.

Type the following statement in the SQL Statements pane of Interactive SQL:

CREATE DATABASE 'c:\\temp\\database-name.db'
TRANSACTION LOG ON
CHECKSUM ON;

Tip

You can also configure database properties such as encryption and page size using the CREATE DATABASE statement. See CREATE DATABASE statement.

From the SQL menu, choose Execute.

A database and transaction log are created in the c:\temp directory of your desktop computer.
Copy the database to your Windows Mobile device.

For information about copying the database to your Windows Mobile device, see Copy a database to your Windows Mobile device.

Discuss this page in DocCommentXchange.