Sybase SQL Anywhere

Remote and mobile-enabled database with powerful data synchronisation technologies

Published By:

Sybase, Inc.

Please see below for licensing options, pricing and availability.
Shipping is free within mainland UK (next working day subject to availability).

Product Variants

For advice on this product or for a quote, please contact us or click here to request a call back.

Product Information

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.

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.