DBMS > H2 vs. Microsoft SQL Server vs. SAP SQL Anywhere
System Properties Comparison H2 vs. Microsoft SQL Server vs. SAP SQL Anywhere
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||H2 Xexclude from comparison||Microsoft SQL Server Xexclude from comparison||SAP SQL Anywhere formerly called Adaptive Server Anywhere Xexclude from comparison|
|Description||Full-featured RDBMS with a small footprint, either embedded into a Java application or used as a database server.||Microsofts flagship relational DBMS||RDBMS database and synchronization technologies for server, desktop, remote office, and mobile environments|
|Primary database model||Relational DBMS||Relational DBMS||Relational DBMS|
|Secondary database models||Spatial DBMS||Document store|
|Developer||Thomas Mueller||Microsoft||SAP formerly Sybase|
|Current release||1.4.200, October 2019||SQL Server 2019, November 2019||17, July 2015|
|License Commercial or Open Source||Open Source dual-licence (Mozilla public license, Eclipse public license)||commercial restricted free version is available||commercial|
|Cloud-based only Only available as a cloud service||no||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Server operating systems||All OS with a Java VM||Linux|
|Typing predefined data types such as float or date||yes||yes||yes|
|XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.||no||yes||yes|
|SQL Support of SQL||yes||yes||yes|
|APIs and other access methods||JDBC|
Tabular Data Stream (TDS)
|Supported programming languages||Java||C#|
|Server-side scripts Stored procedures||Java Stored Procedures and User-Defined Functions||Transact SQL, .NET languages, R, Python and (with SQL Server 2019) Java||yes, in C/C++, Java, .Net or Perl|
|Partitioning methods Methods for storing different data on different nodes||none||tables can be distributed across several files (horizontal partitioning); sharding through federation||none|
|Replication methods Methods for redundantly storing data on multiple nodes||With clustering: 2 database servers on different computers operate on identical copies of a database||yes, but depending on the SQL-Server Edition||Source-replica replication Database mirroring|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Immediate Consistency||Immediate Consistency|
|Foreign keys Referential integrity||yes||yes||yes|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||ACID||ACID|
|Concurrency Support for concurrent manipulation of data||yes, multi-version concurrency control (MVCC)||yes||yes|
|Durability Support for making data persistent||yes||yes||yes|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||yes||yes||yes|
|User concepts Access control||fine grained access rights according to SQL-standard||fine grained access rights according to SQL-standard||fine grained access rights according to SQL-standard|
More information provided by the system vendor
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||DBHawk: Secure access to SQL, NoSQL and Cloud databases with an all-in-one solution.|
General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
Navicat for SQL Server gives you a fully graphical approach to database management and development.
Navicat Monitor is a safe, simple and agentless remote server monitoring tool for SQL Server and many other database management systems.
Fivetran: Quickly and easily centralize your on-premise and cloud databases.
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|H2||Microsoft SQL Server||SAP SQL Anywhere formerly called Adaptive Server Anywhere|
|DB-Engines blog posts|
MySQL is the DBMS of the Year 2019 The struggle for the hegemony in Oracle's database empire
The struggle for the hegemony in Oracle's database empire
|Recent citations in the news|
Learn what makes Microsoft SQL Server a market-leading database technologies with this bundle
Microsoft SQL Server RDBMS Review 2021
Oracle vs SQL Server: RDBMS Comparison 2021
Improve Your Business Intelligence by Mastering Microsoft SQL Server
Daily Deal: The Essential Microsoft SQL Server Training Bundle
provided by Google News
SAP SQL Anywhere
SAP gives SQL Anywhere a new IoT injection
Best Database Management Software 2020
Rimini Street looks beyond Oracle and SAP
SAP IoT products: How do they work with ERP and big data?
provided by Google News
SQL Server Developer
SQL Server DBA
SSIS/ SQL Server
Sql Server Developer
SQL Server/VB Developer
Share this page