SAP SQL Anywhere is a proprietary relational database management system (RDBMS) product from SAP. SQL Anywhere was known as Sybase SQL Anywhere prior to the acquisition of Sybase by SAP.
Features[edit]
Oct 13, 2016 - This definition explains what SAP SQL Anywhere is and how. SAP SQL Anywhere was first released as Sybase SQL Anywhere prior to. Tips for migrating SQL Anywhere DB to MS SQL (mainly for functions) 06 Mar, 08:29 Chris Keating 4.2k stored-procedure stored-function convert-to-sql migration mssql.
SQL Anywhere can be run on Windows, Windows CE, Mac OS X, and various UNIX platforms, including Linux, AIX, HP-UX and 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 procedures, user functions (using Watcom SQL, T-SQL, Java, or C/C++), triggers, referential integrity, row-level locking, replication, high availability, proxy tables, and events (scheduled and system events). Strong encryption is supported for both database files and client-server communication.
Uses[edit]
SQL Anywhere is used in several contexts, including as an embedded database, particularly as an application data store. For example, it is used in IntuitQuickBooks,[1] 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[edit]
SQL Anywhere Server is a high performing and embeddable 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[edit]
- 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 procedures, 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 (MobiLinkdata synchronization, UltraLite mobile database for Palm OS and Windows CE)
- Version 7: 2000 (dynamic cache, task scheduling and event handling, cross-platform administration tools)
- Version 8: 2001 (Volcano query optimizer, encrypted data storage and transmission)
- Version 9: 2003 (Index consultant, embedded HTTP server)
- Version 10: 2006 – renamed SQL Anywhere (high availability, intra-query parallelism, materialized views)[2]
- Version 11: 2008 (full text search, BlackBerry support)[3]
- Version 12: 2010 released by SAP Sybase (support for spatial data)[4][5]
- Version 16: April 18, 2013 – (faster synchronization and improved security)[6]
- Version 17: July 15, 2015; released by SAP [7]
References[edit]
- ^'QuickBooks replaces its flat file system with SQL Anywhere from Sybase iAnywhere'. Sybase.
- ^'Sybase iAnywhere Announces the Release of SQL Anywhere 10'. Sybase press release. August 7, 2006.
- ^'Sybase iAnywhere Announces Availability of SQL Anywhere 11'. Sybase press release. August 5, 2008.
- ^'Sybase Advances its Mobile and Embedded Database Leadership Position with SQL Anywhere 12'. Sybase press release. June 29, 2010.
- ^http://www.sybase.com/files/White_Papers/SQLAnywhere_12_New-Features_WP.pdf
- ^http://www.kessler.de/prd/sybase/Ianywhere16.pdf
- ^https://blogs.sap.com/2015/07/15/announcing-sql-anywhere-17-2/
External links[edit]
Retrieved from 'https://en.wikipedia.org/w/index.php?title=SQL_Anywhere&oldid=837070772'
Sybase announced on Tuesday SQL Anywhere 12, the latest edition of its mobile database and one of the 'crown jewels' SAP will acquire with its pending purchase of the company.
SAP announced plans to buy Sybase earlier this year for $5.8 billion. Since then, SAP executives such as co-CEO Bill McDermott have played a consistent tune, declaring mobile to be 'the new desktop' and pledging that customers will be able to access the vendor's applications anywhere, anyplace, anytime.
SQL Anywhere sits at the core of Sybase's Mobility Platform. A significant focus of version 12 is support for large-scale data synchronization, the process of getting information collected out in the field by workers with mobile devices back into the company's on-premises systems.
![Sybase Sybase](/uploads/1/2/5/8/125825699/274565331.png)
New tools help companies manage, monitor and troubleshoot sync implementations. Customers can also run simulations of sync operations to check for problems before turning on the system.
Sybase has also added self-management capabilities, including automatic tuning of server threads that adapt the system to changing workloads, freeing up time for database administrators.
![Sap Sybase Sql Anywhere Sap Sybase Sql Anywhere](/uploads/1/2/5/8/125825699/371603487.png)
A new server scale-out feature, found in the Advanced Edition version of the product, allows the system to offload work to an array of read-only nodes.
Other features include integrated support for Microsoft Visual Studio 2010 and .NET Framework 4.0. SQL Anywhere 12 is scheduled for release in July, with pricing to be announced at that time, said Mike Paola, director of product management.
In addition, Sybase has added support for iPhones, along with BlackBerries and Windows Mobile.
Thanks to user expectations driven by the consumer world, SAP 'is being pressured to deliver its software on different devices,' said Redmonk analyst Michael Coté. 'Sybase provides an interesting part of the middleware SAP needs.'
SAP will 'be obsessed with perfection' as it builds out its mobile strategy, Coté added. 'They are not going to put up with the sloppy data handling you see in the consumer space. Sybase has that to offer them in the data handling, and more importantly, synchronization space.'
Synchronization is 'a huge issue' and hasn't become a commodity technology yet, he said.
Chris Kanaracus covers enterprise software and general technology breaking news for The IDG News Service. Chris's e-mail address is [email protected]