SQL Anywhere: Difference between revisions

Browse history interactively

← Previous edit

Content deleted Content added

VisualWikitext

Revision as of 13:52, 6 February 2012 edit Czarkoff (talk \| contribs) Extended confirmed users, Pending changes reviewers, Rollbackers 18,495 edits m →History: Disambiguated cache ← Previous edit		Latest revision as of 05:25, 1 June 2025 edit undo Ylee (talk \| contribs) Extended confirmed users, Pending changes reviewers, Rollbackers 48,243 edits →History: New section
(43 intermediate revisions by 32 users not shown)
Line 1: {{about\|the database\|the corporate division\|Sybase iAnywhere}} {{Refimprove\|date=October 2009}}▼ {{redirect-distinguish\|Sybase ASA\|Sybase ASE}} '''SQL Anywhere''' is a [[Relational database management system\|relational database management system (RDBMS)]] product from the company [[Sybase iAnywhere]], a subsidiary of [[Sybase]].▼ ▲{{~~Refimprove~~More citations needed\|date=October 2009}} {{Infobox software \| name = SQL Anywhere \| logo = <!-- Image name is enough. --> \| logo alt = \| logo caption = \| screenshot = <!-- Image name is enough. --> \| screenshot size = \| screenshot alt = \| caption = \| collapsible = <!-- Any text here will collapse the screenshot. --> \| author = \| developer = [[SAP AG\|SAP]] \| released = <!-- {{Start date and age\|YYYY\|MM\|DD\|df=yes/no}} --> \| discontinued = <!-- Set to yes if software is discontinued, otherwise omit. --> \| ver layout = <!-- simple (default) or stacked --> \| latest release version = {{wikidata\|property\|Q2247564\|P348}} \| latest release date = <!-- {{Start date and age\|YYYY\|MM\|DD\|df=yes/no}} --> \| latest preview version = \| latest preview date = <!-- {{Start date and age\|YYYY\|MM\|DD\|df=yes/no}} --> \| repo = <!-- {{URL\|example.org}} --> \| programming language = \| engine = <!-- or engines --> \| operating system = \| platform = \| included with = \| size = \| language = \| language count = <!-- Number only --> \| 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 ~~the company~~ [[~~Sybase~~SAP ~~iAnywhere~~AG\|SAP]],. aSQL ~~subsidiary~~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~~[[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 Line 34 ⟶ 84: }}</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> ~~}}</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> == ~~See~~References ~~also~~== * [[IvanAnywhere]] ~~==References==~~ {{reflist}} == External links == * [~~http~~https://www.~~sybase~~sap.com/products/~~databasemanagement/sqlanywhere~~sql-anywhere.html SQL Anywhere official product page] * [http://www.sybase.com/ianywhere Sybase iAnywhere main page] * [http://www.da-soft.com/anydac/ SQL Anywhere (and more) Data Access Components for Embarcadero Delphi] [[Category:Proprietary database management systems]] [[Category:Relational database management systems]] ~~{{database-stub}}~~ ~~[[es:Adaptive Server Anywhere]]~~ ~~[[it:SQL Anywhere Studio]]~~ ~~[[lv:SQL anywhere]]~~ ~~[[pl:Adaptive Server Anywhere]]~~