Sybase SQL Anywhere

Published By:

Sybase, Inc.

Sybase SQL Anywhere is a high-performance, remote-enabled database for applications that operate outside the traditional data center. It features a self-tuning query optimiser, encryption capabilities, graphical database schema design, management and query editing tools and much more. SQL Anywhere supports a range of interfaces including ADO.NET, OLE DB and ODBC, a range of programming languages including C#, VB.NET, C/C++ and Java, and runs on a variety of operating systems. The powerful data synchronisation features provide robust synchronisation between remote systems and enterprise Microsoft, Oracle, MySQL and IBM databases.

Product Variants

Sybase SQL Anywhere, 11.0

Variant	Manufacturer Part#	Our Part#
v11.0 Advanced Edition, Server with 25 Users Win	19526	341754	Quote
v11.0 Standard Edition, 1-CPU Lic Win	19527	341758	Quote
v11.0 Standard Edition, Annual Support ONLY for 1-CPU Lic, Per CPU Win		371998	Quote
v11.0 Standard Edition, Server with 5 Users Win	19528	341757	Quote
v11.0 Workgroup Edition, Server with 5 Users, Licence	19861	340617	Quote
v11.0 Workgroup Edition, Server with 5 Users, Maintenance ONLY		451381	Quote
v11.0 Workgroup Edition, Server with 10 Users, Licence	17890	341760	Quote

Sybase SQL Anywhere, 12.0

Features

High Performance

A self-tuning query optimiser and dynamic cache sizing features help deliver high performance. SQL Anywhere can handle 20,000 transactions a minute, thousands of users and hundreds of gigabytes of data.

Powerful synchronisation

Enterprise-class synchronisation features provide data synchronisation between remote and enterprise systems including Sybase, Microsoft, Oracle, MySQL and IBM databases.

Other synchronisation features include:

End-to-end encryption of data
Advanced conflict detection and programmable resolution
Support for horizontal and vertical subsetting of data
Optimised for wireless synchronisation.

Feature rich

SQL Anywhere includes powerful features such as OLAP, materialised views, snapshot isolation, full-text search, regular expressions, support for a range of programming languages including C#, VB.NET, C/C++, ASP, Java, PHP, Perl and more with native access through ADO.NET, OLE DB, ODBC, JDBC and Open Client.

Other database features include:

Graphical schema design, database management and query editing tools
Support for stored procedures and triggers
BLOB support
Encryption for database files and network communications
Internationalisation features.

Easy to embed

Numerous self-maintenance features such as automated administration, back-up and tuning, a hidden runtime mode and more, make it easy to embed into your application.

Editions

Workgroup edition

Maximum number of CPUs (sockets) supported: 2
Includes monitoring tool (development and testing)
RSA security option
Server operating systems supported: Windows, Linux, Mac OS X

Standard edition

Maximum number of CPUs (sockets) supported: 4
Includes high availability option
Includes monitoring tool (development and testing)
Includes monitoring tool (deployment)
RSA security option
Server operating systems supported: Windows, Linux, Mac OS X, Solaris, HP-UX, AIX

Advanced edition

Maximum number of CPUs (sockets) supported: unlimited
Includes high availability option
Includes monitoring tool (development and testing)
Includes monitoring tool (deployment)
Supports read-only scale out
Supports in-memory runtime
RSA security option
FIPS security option
Replication server agent
Server operating systems supported: Windows, Linux, Mac OS X, Solaris, HP-UX, AIX.

System Req.

Supported platforms for SQL Anywhere Server

Windows x86 and x64
Windows Mobile
Linux x86 and x64
Sun Solaris SPARC and x64
Mac OS X on Intel
IBM AIX
HP-UX Itanium
Server requires 512MB RAM or greater
Client requires 8MB RAM + 4KB per client connection (8KB for Unix).