SQL Anywhere provides all of the following features:
Full SQL RDBMS SQL Anywhere is a transaction-processing RDBMS with full recovery capabilities, online backup, referential integrity actions, stored procedures, triggers, row-level concurrency control, schedules and events, a rich SQL language, and all the features you expect in a full SQL RDBMS.
Economical hardware requirements SQL Anywhere requires fewer memory and disk resources than other database management systems.
Easy to use SQL Anywhere is self-tuning and easy to manage. You can use SQL Anywhere without the extensive database administration efforts usually associated with RDBMSs.
Standalone and network use SQL Anywhere can be used in a standalone manner, for example as an embedded database in a data-centric application, or as a network server in a multiuser client/server or three-tier environment. As an embedded database system, it can be started automatically by an application when required.
High performance Although SQL Anywhere is designed with simple administration and modest resource requirements in mind, it is a scalable, high-performance DBMS. SQL Anywhere can run on multiple CPUs, has an advanced query optimizer, and provides performance monitoring and tuning tools.
Industry-standard interfaces SQL Anywhere provides a native ODBC driver for high performance from ODBC applications, and an OLE DB driver for use from ActiveX Data Object (ADO) programming environments. It comes with Sybase jConnect for JDBC as well as an iAnywhere JDBC driver, and supports embedded SQL and Sybase Open Client interfaces.
A cross-platform solution SQL Anywhere can be run on many operating systems, including Windows, Windows PocketPC, Windows Mobile 2003, Novell NetWare, Sun Solaris, and Linux.
