SQL Anywhere: Difference between revisions

Browse history interactively

← Previous edit

Content deleted Content added

VisualWikitext

Revision as of 17:31, 24 May 2007 edit Whimsley (talk \| contribs) 107 edits Added usage section ← Previous edit		Latest revision as of 05:25, 1 June 2025 edit undo Ylee (talk \| contribs) Extended confirmed users, Pending changes reviewers, Rollbackers 48,244 edits →History: New section
(123 intermediate revisions by 77 users not shown)
Line 1: {{about\|the database\|the corporate division\|Sybase iAnywhere}} ~~'''SQL Anywhere''' is an [[RDBMS]] product from [[iAnywhere Solutions]]. iAnywhere is a subsidiary of [[Sybase]].~~ {{redirect-distinguish\|Sybase ASA\|Sybase ASE}} {{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 [[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. * Database files are operating-system-independent. This means that they can be copied between supported platforms. * Can be run on [[Microsoft Windows\|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 == Uses == SQL Anywhere is ~~widely~~ used in several contexts, including as an [[embedded database]], particularly as an application data store;. ~~for~~For example, it is used in [[Intuit]] [[QuickBooks]],<ref>{{cite ~~in network management products, backup products, and others. Its ability to be used with minimal administration is a distinguishing feature in this role.~~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 is also widely used for mobile computing. It includes scalable data synchronization technology that provides change-based replication across many databases.~~ 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. ~~There are over 10 million deployed seats of SQL Anywhere.<ref>{{cite web\|title=SQL Anywhere 10 Announcement\|url=http://www.sybase.com/detail?id=1042264}}</ref>~~ ''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. ~~== History ==~~ ''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. * 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'''. ==~~External~~ ~~links~~History == * Initially created by [[Watcom]] as '''Watcom SQL'''. * [http://www.ianywhere.com/ iAnywhere web site] * Version 3: 1992 * [http://ianywhere.com/products/sql_anywhere.html SQL Anywhere page] * Watcom acquired by [[Powersoft]] in 1993; Watcom SQL shipped with their visual programming environment [[PowerBuilder]] [http://www.sybase.com/products/mobilesolutions/sqlanywherestudio SQL Anywhere Studio] 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 == ~~[[es:Adaptive Server Anywhere]]~~ {{reflist}} == External links == ~~[[Category:Database management systems]]~~ * [https://www.sap.com/products/sql-anywhere.html SQL Anywhere official product page] [[Category:Proprietary database management systems]] ~~[[it:SQL Anywhere Studio]]~~ [[Category:Relational database management systems]]