|
This section lists the components and features of SQL Anywhere that are unsupported or have altered functionality on Windows CE. Where available, alternatives to unsupported features are listed.
For more information about supported and unsupported components on Windows CE, see ![[external link]](gif/external.gif)
SQL Anywhere 10.0.1 Components by Platform .
SQL Anywhere includes several tools for administering databases. These include Sybase Central, Interactive SQL, and utilities. None of these administration tools can be deployed to Windows CE. Instead, database administration is performed from a Windows-based computer that is connected to the Windows CE device.
For more information, see Using the administration utilities on Windows CE.
| Component or feature | Considerations |
|---|---|
| Application profiling | When you create a tracing session for a database running on Windows CE, you must configure tracing using the Database Tracing wizard (you cannot use the Application Profiling wizard). As well, you must trace data from the Windows CE device to a copy of the Windows CE database running on a database server on a desktop computer. You cannot automatically create a tracing database from a Windows CE device, and you cannot trace to the local database on a CE device. See Application profiling. |
| Database mirroring | Unsupported on Windows CE. |
| External stored procedures | Unsupported on Windows CE. |
| iAnywhere JDBC driver | Unsupported on Windows CE. You can use jConnect on Windows CE. |
| Java in the database | Unsupported on Windows CE. |
| jConnect | The jConnect driver can be enabled when you create a database for Windows CE. This can be useful if you want to move the database to a computer that supports Java. However, enabling the jConnect driver adds to the size of the database and, more significantly, adds about 200 KB to the memory requirements for running the database. This additional memory requirement should be considered when running the database in a limited-memory environment like Windows CE. |
| Kerberos authentication | Unsupported on Windows CE. |
| LDAP authentication | Unsupported on Windows CE. |
| ODBC clients | Windows CE does not provide an ODBC driver manager or an ODBC Administrator, so SQL Anywhere uses ODBC data sources stored in files. See Using ODBC data sources on Windows CE. |
| Open Client | Unsupported on Windows CE. |
| Parallel backups | Unsupported on Windows CE. |
| Personal database server (dbeng10) | Only the network database server (dbsrv10) is supported on Windows CE. This executable supports local connections and client/server communications across a network. |
| Remote data access (including directory access servers) | Unsupported on Windows CE. |
| SPX protocol | Windows CE uses the TCP/IP protocol. |
This section describes SQL statements that are not supported on Windows CE, as well as those that have altered or limited functionality.
For a complete list of SQL statements, see SQL Statements.
| SQL statement | Considerations |
|---|---|
| BACKUP statement | Only the BACKUP DATABASE DIRECTORY clause is supported on Windows CE. |
| CREATE DATABASE statement | The CREATE DATABASE statement can be used to initialize a database on a computer, which can later be copied to a Windows CE device. See Creating a Windows CE database. |
| CREATE EVENT statement | DiskSpace event types are not supported on Windows CE. However, you can use this statement to define the GlobalAutoIncrement event type or the ServerIdle event type. |
| CREATE EXISTING TABLE statement | Unsupported on Windows CE. |
| CREATE EXTERNLOGIN statement | Unsupported on Windows CE. |
| CREATE FUNCTION statement | The CREATE FUNCTION statement can be used on Windows CE to create user-defined SQL functions for use in the database. Note that the EXTERNAL NAME clause is not supported on Windows CE. |
| CREATE SERVER statement | Unsupported on Windows CE. |
| CREATE TABLE statement | The AT clause of the CREATE TABLE statement for creating proxy tables is not supported on Windows CE. |
| DROP DATABASE statement | Unsupported on Windows CE. |
| DROP SERVER statement | Unsupported on Windows CE. |
| INSTALL JAVA statement | Unsupported on Windows CE. |
| REMOVE JAVA statement | Unsupported on Windows CE. |
| REORGANIZE TABLE statement | Unsupported on Windows CE. |
| RESTORE DATABASE statement | Unsupported on Windows CE. |
| START JAVA statement | Unsupported on Windows CE |
| STOP JAVA statement | Unsupported on Windows CE. |
This section describes those database server options that are not supported or have altered functionality on Windows CE.
| Option | Considerations |
|---|---|
| @ data option | Unsupported on Windows CE. |
| -? server option | Unsupported on Windows CE. |
| -cm server option | Unsupported on Windows CE. |
| -cw server option | Unsupported on Windows CE. |
| -ec server option |
Strong communication encryption is not supported on Windows CE. Only the none and simple settings are supported. See -ec server option. |
| -gb server option | Unsupported on Windows CE. |
| -ge server option | Unsupported on Windows CE. |
| -gss server option | Unsupported on Windows CE. |
| -qi server option | When running, the network database server appears as an icon in the bottom right corner of the Today screen on your Windows CE device. This feature cannot be disabled. |
| -s server option | Unsupported on Windows CE. |
| -tmf server option | Unsupported on Windows CE. |
| -tmt server option | Unsupported on Windows CE. |
| -u server option | Unsupported on Windows CE. |
| -ua server option | Unsupported on Windows CE. |
| -uc server option | Unsupported on Windows CE. |
| -ud server option | Unsupported on Windows CE. |
| -uf server option | Unsupported on Windows CE. |
| -ui server option | Unsupported on Windows CE. |
| -ut server option | Unsupported on Windows CE. |
| -ux server option | Unsupported on Windows CE. |
| -xp server option | Unsupported on Windows CE. |
The following table lists the Sybase Central wizards that are not supported or have altered functionality on Windows CE and provides alternatives where possible.
| Wizard | Considerations |
|---|---|
| Backup Database wizard |
Archive backups are not supported on Windows CE. The Backup Database wizard is not supported. See Types of backup. As an alternative on Windows CE, you can use the Create Backup Images wizard, which makes a separate backup of the database and transaction log files. See Making a backup, continuing to use the original transaction log. |
| Change Log File Settings wizard | Unsupported on Windows CE. |
| Create Database wizard | This wizard provides options for creating database on Windows CE, provided Windows CE services are installed on the computer running Sybase Central. See Creating a Windows CE database. |
| Create Maintenance Plan wizard |
The following options are not available on Windows CE:
|
| Erase Database wizard | Unsupported on Windows CE. |
| Migrate Database wizard | Unsupported on Windows CE. |
| Restore Database wizard | Unsupported on Windows CE. |
| Create Service wizard | Unsupported on Windows CE. |
| Translate Log File wizard | Unsupported on Windows CE. |
| Unload Database wizard | This wizard cannot map to the Windows CE directory where the database files are stored. However, you can unload a Windows CE database by copying it to your computer and using the Unload Database wizard. |
| Upgrade Database wizard | This wizard is not supported on Windows CE. However, you can upgrade a Windows CE database by copying it to your computer and using this wizard before copying the database back to your Windows CE device. See Upgrading databases. |
SQL Remote is supported on Windows CE with the following exceptions:
| Component or feature | Considerations |
|---|---|
| Extraction utility (dbxtract) | Windows CE does not support this utility. If necessary, a Windows CE database can be copied to a computer so that the Extraction utility can be used. |
| MAPI message type | This message system is not supported on Windows CE. |
| VIM message type | This message system is not supported on Windows CE. |