SQL Anywhere: Difference between revisions

Browse history interactively

← Previous edit

Content deleted Content added

VisualWikitext

Revision as of 15:41, 18 December 2013 edit ChrisGualtieri (talk \| contribs) Pending changes reviewers, Rollbackers 457,369 edits m Remove stub template(s). Page is start class or higher. Also check for and do General Fixes + Checkwiki fixes using AWB ← 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
(33 intermediate revisions by 23 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 [[Sybase iAnywhere]], an [[SAP AG\|SAP]] company.▼ ▲{{~~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 [[~~Sybase~~SAP ~~iAnywhere~~AG\|SAP]],. anSQL Anywhere was known as '''Sybase SQL Anywhere''' prior to the acquisition of [[~~SAP AG\|SAP~~Sybase]] ~~company~~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 == Line 13 ⟶ 54: 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. Line 26 ⟶ 66: == 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 44 ⟶ 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><ref>http://www.sybase.com/files/White_Papers/SQLAnywhere_12_New-Features_WP.pdf</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 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] [[Category:Proprietary database management systems]]