SQL Anywhere: Difference between revisions

Revision as of 11:04, 2 March 2020

Latest revision as of 05:25, 1 June 2025

(8 intermediate revisions by 7 users not shown)

Line 1:

{{about|the database|the corporate division|Sybase iAnywhere}}

{{redirect-distinguish|Sybase ASA|Sybase ASE}}

{{RefimproveMore citations needed|date=October 2009}}

{{Infobox software

| name = SQL Anywhere

Line 17:

| 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 =

Line 32:

| language footnote =

| genre = Database

| license = Proprietary{{wikidata|property|Q2247564|P275}}

| alexa =

| website = {{URL|https://www.sap.com/products/sql-anywhere.html}}

Line 38:

| 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 ==

Line 61 ⟶ 64:

''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.

== Differences between SAP ASE and SAP Sybase SQL Anywhere == <ref>{{Cite web|url=https://wiki.scn.sap.com/wiki/display/SQLANY/SAP+SQL+Anywhere|title=SAP SQL Anywhere Software Solutions|website=SAP}}</ref>

'''SQL Anywhere''' databases are designed for a full range of functionality including enterprise servers, embedded applications, desktop servers, remote offices, and mobile applications.  The SQL Anywhere database is designed to be self managing, requiring no DBA to constantly maintain the database system. Everything is in the box with SQL Anywhere.

SQL Anywhere is a lot cheaper: purchase price, licensing fees, AND the price you won't have to pay for all the technical support. Especially because you only have one thing to buy.

'''<u>The SQL Anywhere database is light weight, but still offers full enterprise features such as:</u>'''

* High Availability

* Database Clustering

* Snapshot Isolation

* Materialized Views

* Built-in Web Services Server

* Self-tuning Query Optimizer

<u>'''SAP ASE is a fully featured enterprise database server designed specifically for mission-critical data management systems and ASE offers features such as:'''</u>

* High Availability

* Encrypted Columns

* Advanced Security

* Distributed Transactions

* Content Management

* Data Partitioning

For example, SAP ASE is having multiple components for respective functionality and expensive compared to SQL Anywhere: if you want to replicate data between Oracle and ASE, you have to buy ASE, then you have to buy Replication Server, then you have to buy the Oracle version of something call "Replication Server Options". With SQL Anywhere, MobiLink is in the box, and so is the interface for Oracle. And the docs are all in one Help file too.

== History ==

Line 107 ⟶ 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

Line 118 ⟶ 95:

|date=June 29, 2010

}}</ref><ref>{{Cite web|url=https://www.sap.com/index.html|title=SAP Software Solutions &#124; 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! &#124; SAP Blogs|website=blogs.sap.com}}</ref>