imported>Ylee: /* History */ New section

2025-06-01T05:25:31Z

History: New section

New page

{{about|the database|the corporate division|Sybase iAnywhere}}
{{redirect-distinguish|Sybase ASA|Sybase ASE}}
{{More citations needed|date=October 2009}}
{{Infobox software
| name = SQL Anywhere
| logo = 
| logo alt =
| logo caption =
| screenshot = 
| screenshot size =
| screenshot alt =
| caption =
| collapsible = 
| author =
| developer = [[SAP AG|SAP]]
| released = 
| discontinued = 
| ver layout = 
| latest release version = {{wikidata|property|Q2247564|P348}}
| latest release date = 
| latest preview version =
| latest preview date = 
| repo = 
| programming language =
| engine = 
| operating system =
| platform =
| included with =
| size =
| language =
| language count = 
| language footnote =
| genre = Database
| license = {{wikidata|property|Q2247564|P275}}
| alexa =
| website = {{URL|https://www.sap.com/products/sql-anywhere.html}}
| standard =
| AsOf =
}}
'''SAP SQL Anywhere''' is a proprietary [[Relational database management system|relational database management system (RDBMS)]] product from [[SAP AG|SAP]]. SQL Anywhere was known as '''Sybase SQL Anywhere''' prior to the acquisition of [[Sybase]] by SAP.

==History==
The database company [[Sybase]] obtained the SQL Anywhere technology as part of its acquisition of [[PowerBuilder]] vendor PowerSoft.<ref name="rdbmsingressybase20070613">{{Cite interview |interviewer=Doug Jerger |title=RDBMS Workshop: Ingres and Sybase |url=https://archive.computerhistory.org/resources/access/text/2013/05/102702565-05-01-acc.pdf |access-date=2025-05-30 |publisher=Computer History Museum |date=2007-06-13}}</ref>

== Features ==
SQL Anywhere can be run on [[Microsoft Windows|Windows]], [[Windows CE]], [[Mac OS X]], and various [[UNIX]] platforms, including [[Linux]], [[AIX]], [[HP-UX]] and [[Solaris (operating system)|Solaris]]. Database files are independent of the [[operating system]], allowing them to be copied between supported platforms. The product provides several standard interfaces ([[ODBC]], [[JDBC]], and [[ADO.NET]]) and a number of special interfaces such as [[PHP]] and [[Perl]]. The engine supports [[stored procedure]]s, user functions (using [[Watcom SQL]], [[T-SQL]], [[Java (software platform)|Java]], or [[C (programming language)|C]]/[[C++]]), [[Database trigger|triggers]], [[referential integrity]], row-level locking, [[Replication (computer science)|replication]], [[Cluster (computing)|high availability]], [[Default gateway|proxy tables]], and events (scheduled and system events). [[Strong encryption]] is supported for both database files and client-server communication.

== Uses ==
SQL Anywhere is used in several contexts, including as an [[embedded database]], particularly as an application data store. For example, it is used in [[Intuit]] [[QuickBooks]],<ref>{{cite web
|title=QuickBooks replaces its flat file system with SQL Anywhere from Sybase iAnywhere
|url=http://www.sybase.com/detail?id=1061721
|publisher=Sybase
}}</ref> in network management products, and in backup products. Its ability to be used with minimal administration is a distinguishing feature in this role.
It can be used as a [[database server]] for work groups or for small or medium-sized businesses. It can also function as a [[mobile database]]. It includes scalable [[data synchronization]] technology that provides change-based replication between separate databases, including large server-based RDBMS systems.

== Technologies ==
SQL Anywhere Server is a high performing and embeddable relational database-management system ([[Relational database management system|RDBMS]]) that scales from thousands of users in server environments down to desktop and mobile applications used in widely deployed, zero-administration environments.

''Ultralite'': UltraLite is a database-management system designed for small-footprint mobile devices such as PDAs and smart phones.

''Mobilink'': MobiLink is a highly-scalable, session-based synchronization technology for exchanging data among relational databases and other non-relational data sources.

''QAnywhere'': QAnywhere facilitates the development of robust and secure store-and-forward mobile messaging applications.

''SQL Remote'': SQL Remote technology is based on a store and forward architecture that allows occasionally connected users to synchronize data between SQL Anywhere databases using a file or message transfer mechanism.

== History ==
* Initially created by [[Watcom]] as '''Watcom SQL'''.
* Version 3: 1992
* Watcom acquired by [[Powersoft]] in 1993; Watcom SQL shipped with their visual programming environment [[PowerBuilder]]
* Version 4: 1994 ([[Stored procedure]]s, [[database trigger|triggers]])
* [[PowerSoft]] and [[Sybase]] merged in 1995: Watcom SQL was renamed '''SQL Anywhere'''.
* Version 5: 1995 (SQL Remote [[data replication]]; graphical administration tools)
* Version 6: 1998. Renamed '''Adaptive Server Anywhere''' ('''ASA'''). (multi-processor support, Java objects in the database)
* Version 6.0.2: 1999 ([[Sybase MobiLink|MobiLink]] [[data synchronization]], UltraLite mobile database for [[Palm OS]] and [[Windows CE]])
* Version 7: 2000 (dynamic [[database cache|cache]], task scheduling and event handling, cross-platform administration tools)
* Version 8: 2001 (Volcano [[query optimizer]], [[encryption|encrypted]] data storage and transmission)
* Version 9: 2003 ([[Index (database)|Index]] consultant, [[embedded HTTP server]])
* Version 10: 2006 – renamed '''SQL Anywhere''' ([[high availability]], intra-query [[parallel computing|parallelism]], [[materialized view]]s)<ref>{{cite web
|title=Sybase iAnywhere Announces the Release of SQL Anywhere 10
|url=http://www.sybase.com/detail?id=1042264
|publisher=Sybase press release
|date=August 7, 2006
}}</ref>
* Version 11: 2008 (full text search, [[BlackBerry]] support)<ref>{{cite web
|title=Sybase iAnywhere Announces Availability of SQL Anywhere 11
|url=http://www.sybase.com/detail?id=1057559
|publisher=Sybase press release
|date=August 5, 2008
}}</ref>
* Version 12: 2010 released by SAP Sybase (support for [[Geodata|spatial data]])<ref>{{cite web
|title=Sybase Advances its Mobile and Embedded Database Leadership Position with SQL Anywhere 12
|url=http://www.sybase.com/detail?id=1080500
|publisher=Sybase press release
|date=June 29, 2010
}}</ref><ref>{{Cite web|url=https://www.sap.com/index.html|title=SAP Software Solutions | Business Applications and Technology|website=SAP}}</ref>
* Version 16: April 18, 2013 – (faster synchronization and improved security)<ref>{{Cite web |url=http://www.kessler.de/prd/sybase/Ianywhere16.pdf |title=Archived copy |access-date=2013-07-01 |archive-date=2014-02-11 |archive-url=https://web.archive.org/web/20140211065159/http://www.kessler.de/prd/sybase/Ianywhere16.pdf |url-status=dead }}</ref>
* Version 17: July 15, 2015; released by SAP <ref>{{Cite web|url=https://blogs.sap.com/2015/07/15/announcing-sql-anywhere-17-2/|title=Announcing SQL Anywhere 17! | SAP Blogs|website=blogs.sap.com}}</ref>

== References ==
{{reflist}}

== External links ==
* [https://www.sap.com/products/sql-anywhere.html SQL Anywhere official product page]

[[Category:Proprietary database management systems]]
[[Category:Relational database management systems]]

SQL Anywhere - Revision history

imported>Ylee: /* History */ New section