Sybase ASA

From Wikipedia, the free encyclopedia

This article may require cleanup to meet Wikipedia's quality standards.
Please discuss this issue on the talk page or replace this tag with a more specific message.
This article has been tagged since November 2006.

It has been suggested that this article or section be merged with SQL Anywhere. (Discuss)

Adaptive Server Anywhere (ASA) is a zero-administration full-featured RDBMS from iAnywhere Solutions. iAnywhere is a subsidiary of Sybase.

[edit] Features

Database files are operating-system-independent. This means that they can be copied between supported platforms.
Can be run on Windows, Windows CE, Novell NetWare, and various UNIX platforms, including Linux.
Has several standard interfaces (ODBC, JDBC, ADO.NET) and some special interfaces (eg. PHP).
Supports stored procedures and user functions (using Watcom SQL, T-SQL, or Java), triggers, referential integrity, row-level locking, replication (two technologies: SQL Remote, MobiLink), proxy tables (links to other databases), and events (both scheduled and in response to system events such as lack of free disk space)
Supports strong encryption of both database files and client-server communication
Version 10 supports materialized views, database mirroring, server clustering, and snapshot isolation

[edit] History

Initially created by Watcom and was called Watcom SQL.
Watcom was acquired by PowerSoft in 1993, and Watcom SQL was shipped with their visual programming environment PowerBuilder. PowerSoft released Watcom SQL Server version 4.0.
In 1995, PowerSoft and Sybase merged and Watcom SQL was renamed SQL Anywhere. The first version released under this name was 5.0.
In 1997, SQL Anywhere was renamed Adaptive Server Anywhere, and version 6.0 was released. The name remained until version 10.0, released in September 2006, when the product was renamed back to SQL Anywhere.