The following table lists common database server features and how they differ between personal database servers and network database servers.
| Feature | Network database server (dbsrv12) | Personal database server (dbeng12) |
|---|---|---|
| Checkpoints | DBA authority is required to use the CHECKPOINT statement. | No permissions are required to use the CHECKPOINT statement. |
| Communication packet compression | Supported. | Unsupported. |
| Connecting to the utility database | By default, no connections are allowed to the utility database. You must use the -su option to specify the password for connecting to the utility database. See -su dbeng12/dbsrv12 server option. | By default, connections to the utility database are allowed with the user ID DBA and any password. |
| Connection types | Shared memory and TCP/IP by default. | Shared memory by default. To connect with the TCP/IP protocol use the -x option. See -x dbeng12/dbsrv12 server option. |
| Database mirroring | Supported. See Database mirroring. | Unsupported. |
| LDAP | Can only be used with TCP/IP. See Connecting using an LDAP server. | Unsupported. |
| Multiprogramming level tuning | Supported. See Database server configuration of the multiprogramming level. | Unsupported. |
| Network communications | Supported. | Unsupported. |
| Number of connections | Limited by license. See Editions and licensing. | Maximum of ten simultaneous connections. |
| Number of CPUs | Limited by license. | One. |
| Read-only scale-out | Supported. See SQL Anywhere read-only scale-out. | Unsupported. |
| Windows Mobile | Supported. See SQL Anywhere for Windows Mobile. | Unsupported. |
Server and database options Database server properties |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |