SQL Anywhere has different editions (Edge, advanced) and licensing models (per core, per named user, per device...). Some of them were recently deprecated by SAP, others are still valid. This may create some confusion as to which edition, type of license and capacity is the right fit for a given project.
Below are some definitions to clarify this matter.
Entry-level version of SQL Anywhere 17.
Per named users or per core licenses (4 or 8 cores only) are available.
This is the High-end version of SQL Anywhere 17.
Per named users or per core licenses are available.
Compared to Edge, Advanced supports more OS and provides more features (high availability, production tools). See feature Matrix.
DB & Sync Client is an add-on to per-named user Server licenses (Edge or Advanced).
In the Editions described above (Edge, Advanced…), the database is running on a server and clients access concurrently this server DB.
A Personal Database license adds the possibility to run an additional database on a client, providing a local storage to the client device:
Core and Named-users are alternative licensing models in a client/server scenario.
Any SQL Anywhere Server is either:
It's important to note the difference between "DB & Sync Client" (per device) and per-named user Server (per users).
The SAP literature explains that the DB & Sync Client "allows one (1) device to access the multi-user database server of SAP SQL Anywhere or the SAP SQL Anywhere remote database components (such as the Personal Server with Synchronization or UltraLite with Synchronization)."
Since this license is per device, and the Server is per named users, the end result is a combination of these 2 types of licenses.
In the example of a server with an existing 5 named-users Edge license:
Workgroup Edition was the previous name of the "Edge" Edition and was limited to 2 CPUs.
In order to better guide older customers, the name "SAP SQL Anywhere Workgroup, Edge edition" is sometimes used in the SQL Anywhere literature.
This edition is now obsolete, and was previously positioned between "Workgroup" and "Advanced". Customers could purchase a per-chip (CPU) Standard License, up to 4 Chips.
Feature | Edge | Advanced |
---|---|---|
General | ||
Maximum number of cores | 8 | Not limited |
SQL Anywhere Server | ||
Operating systems1 | Windows Linux OS X |
Windows Linux OS X Solaris AIXHP-UX IA64 |
Options | ||
High Availability | n/a | X |
Monitoring Tool - development & testing | X | X |
Monitoring Tool - production deployment | n/a | X |
Read-Only Scale-Out | n/a | X |
In-Memory Runtime | n/a | X |
RSA Security | X | X |
FIPS Security | O | X |
MobiLink Synchronization Server | ||
Operating systems1 | Windows Linux OS X |
Windows Linux OS X Solaris SPARC AIX |
Database & Sync Client | ||
Personal Server (Local DB on Client PC) | U | U |
UltraLite2 (Local DB on Mobile Device) | U | U |
1 Please consult this page for a comprehensive listing of platforms supported for specific SAP SQL Anywhere components
2 Supported platforms for UltraLite can be found at the link in note 1 above.
Legend