Developer(s) | SAP |
---|---|
Type | Database |
License | Proprietary |
Website | www.sap.com/products/sql-anywhere.html |
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]
SAP SQL Anywhere 17 on Windows 10 SAP SQL Anywhere 17 was announced in June 2015. It is a nice database and I always liked it, because it just works! I have written a number of articles on the earlier versions and of course I wanted to try this latest version. The product you get is a developer edition good for developing on your machine. Unfortunately, the SQL Anywhere Web Edition has been discontinued and is no longer available. The SQL Anywhere Developer Edition is licensed solely for internal evaluation, development and testing of applications compatible with SQL Anywhere.
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.
- ^'SAP Software Solutions | Business Applications and Technology'. SAP.
- ^http://www.kessler.de/prd/sybase/Ianywhere16.pdf
- ^'Announcing SQL Anywhere 17! | SAP Blogs'. blogs.sap.com.
External links[edit]
Retrieved from 'https://en.wikipedia.org/w/index.php?title=SQL_Anywhere&oldid=919854269'
SQL Anywhere Developer Edition 12.0.2484
![Anywhere Anywhere](http://www.stylusstudio.com/images/database/xquery-sybase.gif)
Sybase Inc. in Web Development
![Sql developer licensing faq Sql developer licensing faq](https://support.microsoft.com/Library/Images/3118884.jpg)
Feature-Rich Development of Online Apps
* PHP, Python, Ruby on Rails, AJAX, Java, ASP.NET, Perl, Flex and Silverlight.
* Triggers and stored procedures written in SQL, PHP, Java, .NET and Perl.
* Support for XML, Web Services and full-text search.
* PHP, Python, Ruby on Rails, AJAX, Java, ASP.NET, Perl, Flex and Silverlight.
* Triggers and stored procedures written in SQL, PHP, Java, .NET and Perl.
* Support for XML, Web Services and full-text search.
Feature-Rich Development of Online Apps
* PHP, Python, Ruby on Rails, AJAX, Java, ASP.NET, Perl, Flex and Silverlight.
* Triggers and stored procedures written in SQL, PHP, Java, .NET and Perl.
* Support for XML, Web Services and full-text search.
Pain-Free Administration & Performance
* Out-of-the-box performance with self-tuning query optimizer and dynamic cache sizing.
* Automatically back up databases and recover from system failures.
* Monitor and optimize performance with graphical tools like Index Consultant and Application Profiling Wizard.
Build Offline Web Applications
* File and database synchronization between Web server and laptop/desktop.
* Built-in local Web server with PHP support.
* Encryption to hide code and data from unauthorized access.
* Wizard to create synchronization logic.
* Database synchronization for Gears, an open source browser plug-in
FEATURES :
* With self-tuning query optimizer and dynamic cache sizing features, data-driven applications built with SQL Anywhere require little to no DBA support to provide a powerful application. SQL Anywhere applications handle 20,000 transactions per minute, thousands of users and hundreds of gigabytes of data.
* Data-driven applications are able to integrate securely and reliably with databases using enterprise-class synchronization features provided in SQL Anywhere. It is the only synchronization technology that provides data synchronization between the leading mobile devices and Sybase, Microsoft, Oracle, MySQL and IBM databases in the enterprise.
* Developers will appreciate the advanced features, platform flexibility, and compliance with SQL and ANSI standards when building a data-driven application with SQL Anywhere. Features like OLAP, materialized views, snapshot isolation, full-text search, regular expressions, support for C#, VB.NET, C/C++, ASP, Java, PHP and Perl and other development languages, native access through ADO.NET, OLE DB, ODBC 3.5/level 2, JDBC 3.0 and Open Client and support for over 17 operating systems, SQL Anywhere is the ideal database technology for growing enterprises and application vendors. Client interfaces supported by SQL Anywhere.
* SQL Anywhere was built from inception to be embedded into a server, remote workgroup or mobile application. Its many self-maintenance features like automated administration, back-up and tuning, hidden runtime mode, and an installation process that can be integrated with your application, makes it very easy to broadly deploy with any software application.
LIMITATIONS : Limited to development and test only
Sybase SQL Anywhere provides out-of-box performance, advanced synchronization. It is a feature-rich, easily embedded application which offers support for many programming languages.
SQL Anywhere Developer Edition 12.0.2484 Web Development software developed by Sybase Inc. The license of this web development software is demo, you can free download and get a free trial before you buy a registration or license. Do not use illegal warez version, crack, serial numbers, registration codes, pirate key for this web development software SQL Anywhere Developer Edition. If you want to get a full and unlimited version of SQL Anywhere Developer Edition, you should buy from original publisher Sybase Inc.
* PHP, Python, Ruby on Rails, AJAX, Java, ASP.NET, Perl, Flex and Silverlight.
* Triggers and stored procedures written in SQL, PHP, Java, .NET and Perl.
* Support for XML, Web Services and full-text search.
Pain-Free Administration & Performance
* Out-of-the-box performance with self-tuning query optimizer and dynamic cache sizing.
* Automatically back up databases and recover from system failures.
* Monitor and optimize performance with graphical tools like Index Consultant and Application Profiling Wizard.
Build Offline Web Applications
* File and database synchronization between Web server and laptop/desktop.
* Built-in local Web server with PHP support.
* Encryption to hide code and data from unauthorized access.
* Wizard to create synchronization logic.
* Database synchronization for Gears, an open source browser plug-in
FEATURES :
* With self-tuning query optimizer and dynamic cache sizing features, data-driven applications built with SQL Anywhere require little to no DBA support to provide a powerful application. SQL Anywhere applications handle 20,000 transactions per minute, thousands of users and hundreds of gigabytes of data.
* Data-driven applications are able to integrate securely and reliably with databases using enterprise-class synchronization features provided in SQL Anywhere. It is the only synchronization technology that provides data synchronization between the leading mobile devices and Sybase, Microsoft, Oracle, MySQL and IBM databases in the enterprise.
* Developers will appreciate the advanced features, platform flexibility, and compliance with SQL and ANSI standards when building a data-driven application with SQL Anywhere. Features like OLAP, materialized views, snapshot isolation, full-text search, regular expressions, support for C#, VB.NET, C/C++, ASP, Java, PHP and Perl and other development languages, native access through ADO.NET, OLE DB, ODBC 3.5/level 2, JDBC 3.0 and Open Client and support for over 17 operating systems, SQL Anywhere is the ideal database technology for growing enterprises and application vendors. Client interfaces supported by SQL Anywhere.
* SQL Anywhere was built from inception to be embedded into a server, remote workgroup or mobile application. Its many self-maintenance features like automated administration, back-up and tuning, hidden runtime mode, and an installation process that can be integrated with your application, makes it very easy to broadly deploy with any software application.
LIMITATIONS : Limited to development and test only
Sybase SQL Anywhere provides out-of-box performance, advanced synchronization. It is a feature-rich, easily embedded application which offers support for many programming languages.
SQL Anywhere Developer Edition 12.0.2484 Web Development software developed by Sybase Inc. The license of this web development software is demo, you can free download and get a free trial before you buy a registration or license. Do not use illegal warez version, crack, serial numbers, registration codes, pirate key for this web development software SQL Anywhere Developer Edition. If you want to get a full and unlimited version of SQL Anywhere Developer Edition, you should buy from original publisher Sybase Inc.
File Size:License: DemoPrice:
Related:Enterprise Mobility - Enterprise Mobility Software - Enterprise Mobility Solutions - Enterprise Mobility Systems - Capital Markets - Capital Markets Solutions - Capital Markets Analytics - Business Intelligence - Business Intelligence Management - Business Intelligence SoftwareCapital Markets - Business Intelligence - Enterprise Mobile Software - Enterprise Management - Enterprise Content Management - Markets - Vertical Markets - Stock Markets Maps - Enterprise Im - Enterprise -
Platform: Windows
Downloads: 117 Category: Web Development