Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Starting and connecting to your database » Using SQL Anywhere database servers

 

Database server differences

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