Creating a Windows Mobile database using the CREATE DATABASE statement

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.

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

If the Connect window does not appear automatically, click SQL » Connect.
Click the Identification tab and complete the following fields:
- User ID Type DBA.
- Password Type sql.
- Action Click Connect With An ODBC Data Source.
- ODBC Data Source Name Click Browse, choose the MobileServer data source that you created in Creating 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, click 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 Copying a database to your Windows Mobile device.

Discuss this page in DocCommentXchange.