SQL Anywhere 11.0.1 FAQs
What new editions are being introduced in SQL Anywhere 11.0.1?
SQL Anywhere 11.0.1 marks the introduction of a new Educational Edition. This is a free version of SQL Anywhere available to post-secondary students and staff for instructional, research, and other academic purposes.
We have also replaced the Base Edition with new editions that include different options, platforms and limitations. Now available in 11.0.1 are the following:
- SQL Anywhere Workgroup Edition (5-User, 10-User, 1-CPU packages)
- SQL Anywhere Standard Edition (5-User, 1-CPU packages)
- SQL Anywhere Advanced Edition (25-User, 1-CPU packages)
CPU is defined as a processing unit that may incorporate one or more cores.
What editions are no longer available with SQL Anywhere 11.0.1?
SQL Anywhere Base Edition was a non-OEM version of SQL Anywhere licensed on a per-seat or per-CPU basis. It was available as a 5-User, 10-User, or 1-CPU package. SQL Anywhere Base Edition is replaced by the new Workgroup, Standard, and Advanced editions.
What editions remain the same from SQL Anywhere 11.0.0 to 11.0.1?
The SQL Anywhere Developer, Web, and OEM editions continue to be available with SQL Anywhere 11.0.1. There are no changes to the restrictions for these editions.
SQL Anywhere Developer Edition is a free version of SQL Anywhere available for internal evaluation, development and testing of applications. This edition provides developers an opportunity to freely evaluate the full functionality of SQL Anywhere.
SQL Anywhere Web Edition is a free version of SQL Anywhere available for the development and deployment of web applications using Java, ASP.NET, PHP, and more. The SQL Anywhere Web Edition may be used only for web browser applications.
SQL Anywhere OEM Edition is a version of SQL Anywhere available to OEM partners who wish to embed a version of SQL Anywhere within their own application. With the OEM edition of SQL Anywhere, an OEM partner's application is authenticated for use with the SQL Anywhere database engine.
What are the high-level differences between the SQL Anywhere Workgroup, Standard, and Advanced editions?
SQL Anywhere Workgroup Edition includes the same feature set as SQL Anywhere Base Edition but is restricted to using a maximum of 2 CPUs. It is available only on Windows, Linux, and Mac OS X platforms.
SQL Anywhere Standard Edition includes all of the features of the Workgroup Edition in addition to the High Availability option and SQL Anywhere Monitor. SQL Anywhere Standard Edition is restricted to using a maximum of 4 CPUs, and is available on all supported platforms.
SQL Anywhere Advanced Edition includes all of the features of the Standard Edition in addition to Replication Agent, In-Memory Mode, and FIPS Security. SQL Anywhere Advanced Edition does not restrict the maximum number of CPUs, and is available on all supported platforms.
Has the OEM Edition changed as a result of these new editions?
No, the feature set, platform availability, and the unrestricted number of licensed CPUs remains the same in the OEM Edition. In addition, add-ons will continue to be available to OEMs on an ‘à la carte' basis as it always has been in the past.
Do the CPU limitations in the Workgroup and Standard editions also apply to the free Developer, Web, and Educational editions?
No. The Developer, Web, and Educational Editions are not restricted with respect to maximum number of CPUs supported.
If I currently have a SQL Anywhere 9.x or 10.x Base Edition package, which edition should I migrate to?
This will really depend on your requirements and will likely be driven by the additional features, platform availability, and restrictions that are included in the different editions. For example, the Workgroup Edition may be sufficient if SQL Anywhere will be used on a single or dual-CPU Windows system. If you require SQL Anywhere on a platform such as HP-UX, AIX, or Solaris SPARC, or you require the use of more than 2 CPUs, then the Standard Edition may be more appropriate for your needs. The Advanced Edition would be required if you need to use more than 4 CPUs on a system, or require features such as FIPS security, in-memory mode, or use within a Sybase Replication Server environment.
I noticed SQL Anywhere Monitor in the Workgroup Edition. Do you require SQL Anywhere Standard Edition or Advanced Edition for this feature?
All editions of SQL Anywhere include a version of the SQL Anywhere Monitor for internal evaluation, development and testing only. This version cannot be used to monitor SQL Anywhere or MobiLink servers in a production environment. In the Standard and Advanced editions, an independent SQL Anywhere Monitor is included for installation on a separate computer and can be used to monitor SQL Anywhere or MobiLink servers in a production environment.
I currently have SQL Anywhere 11.0.0. Which edition do I get if I apply the 11.0.1 maintenance release?
If you are upgrading SQL Anywhere Base Edition from 11.0.0 to 11.0.1, the default upgrade will be to SQL Anywhere Workgroup Edition. If, however, your SQL Anywhere server currently uses more than 2 CPUs, or you use an add-on option or run on a platform not available in the Workgroup Edition, you will get a free upgrade to match your current functionality. Contact your local Sybase Support or Customer Service contact in this situation.
I use more than 2 CPUs with my current SQL Anywhere 11.0.0 installation – how can I continue to use that configuration?
As stated above, if your SQL Anywhere server currently uses more than 2 CPUs, or you use an add-on option or platform not available in the Workgroup Edition, you will get a free upgrade to match your current functionality. We will send you a registration key that can be used to apply the upgrade. This is done by re-running the 11.0.1 installation program and entering this registration key when prompted.
If I use an option in 11.0.0 that is now included as part of Standard Edition or Advanced Edition (eg. High Availability), will the 11.0.1 maintenance install remove this option when I upgrade to Workgroup Edition?
No. The install will detect that a previous add-on has been installed and it will remain enabled on that computer.
Now that the new editions bundle various options, will the options continue to be available on an "à la carte" basis?
Add-ons will still be available for the OEM Edition or for versions prior to 11.0.1. Generally, options will not be available for the 11.0.1 packages. For example, if you have purchased the 11.0.1 Workgroup Edition, you cannot purchase the High Availability option for it. You will need to purchase the Standard Edition.