DB-EnginesExtremeDB: the mission critical dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Microsoft SQL Server vs. SAP HANA vs. SQLite

System Properties Comparison Microsoft SQL Server vs. SAP HANA vs. SQLite

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameMicrosoft SQL Server  Xexclude from comparisonSAP HANA  Xexclude from comparisonSQLite  Xexclude from comparison
DescriptionMicrosofts flagship relational DBMSIn-memory, column based data store. Available as appliance or cloud serviceWidely used embeddable, in-process RDBMS
Primary database modelRelational DBMSRelational DBMSRelational DBMS
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
Document store
Graph DBMS infowith SAP Hana, Enterprise Edition
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score902.22
Rank#3  Overall
#3  Relational DBMS
Score50.61
Rank#22  Overall
#16  Relational DBMS
Score129.20
Rank#9  Overall
#6  Relational DBMS
Websitewww.microsoft.com/­en-us/­sql-serverwww.sap.com/­products/­hana.htmlwww.sqlite.org
Technical documentationlearn.microsoft.com/­en-US/­sql/­sql-serverhelp.sap.com/­hanawww.sqlite.org/­docs.html
DeveloperMicrosoftSAPDwayne Richard Hipp
Initial release198920102000
Current releaseSQL Server 2022, November 20222.0 SPS07 (April 4, 2023), April 20233.43.1  (11 September 2023), September 2023
License infoCommercial or Open Sourcecommercial inforestricted free version is availablecommercialOpen Source infoPublic Domain
Cloud-based only infoOnly available as a cloud servicenono infoalso available as a cloud based serviceno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++C
Server operating systemsLinux
Windows
Appliance or cloud-serviceserver-less
Data schemeyesyesyes infodynamic column types
Typing infopredefined data types such as float or dateyesyesyes infonot rigid because of 'dynamic typing' concept.
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.yesnono
Secondary indexesyesyesyes
SQL infoSupport of SQLyesyesyes infoSQL-92 is not fully supported
APIs and other access methodsADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
JDBC
ODBC
ADO.NET infoinofficial driver
JDBC infoinofficial driver
ODBC infoinofficial driver
Supported programming languagesC#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
Actionscript
Ada
Basic
C
C#
C++
D
Delphi
Forth
Fortran
Haskell
Java
JavaScript
Lisp
Lua
MatLab
Objective-C
OCaml
Perl
PHP
PL/SQL
Python
R
Ruby
Scala
Scheme
Smalltalk
Tcl
Server-side scripts infoStored proceduresTransact SQL, .NET languages, R, Python and (with SQL Server 2019) JavaSQLScript, Rno
Triggersyesyesyes
Partitioning methods infoMethods for storing different data on different nodestables can be distributed across several files (horizontal partitioning); sharding through federationyesnone
Replication methods infoMethods for redundantly storing data on multiple nodesyes, but depending on the SQL-Server Editionyesnone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes infovia file-system locks
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesyes
User concepts infoAccess controlfine grained access rights according to SQL-standardyesno

More information provided by the system vendor

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services
3rd partiesNavicat for SQL Server gives you a fully graphical approach to database management and development.
» more

DBHawk: Secure access to SQL, NoSQL and Cloud databases with an all-in-one solution.
» more

Navicat Monitor is a safe, simple and agentless remote server monitoring tool for SQL Server and many other database management systems.
» more
CData: Connect to Big Data & NoSQL through standard Drivers.
» more
Navicat for SQLite is a powerful and comprehensive SQLite GUI that provides a complete set of functions for database management and development.
» more

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
Microsoft SQL ServerSAP HANASQLite
DB-Engines blog posts

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

Microsoft SQL Server is the DBMS of the Year
4 January 2017, Matthias Gelbmann, Paul Andlinger

show all

Big gains for Relational Database Management Systems in DB-Engines Ranking
2 February 2016, Matthias Gelbmann

show all

Recent citations in the news

How to connect to SQL Server from MacOS
22 September 2023, MacRumors

Fix Unable to Install SQL Server on Windows 11
19 September 2023, TheWindowsClub

5 Questions to Ask About Upgrading Microsoft SQL Server
8 September 2023, StateTech Magazine

How To Filter SQL Server Data in Windows PowerShell
15 September 2023, ITPro Today

Expect SQL Server failures as Microsoft disables old TLS in Windows
5 September 2023, CSO Online

provided by Google News

SAP Products Market Analysis 2023: Upcoming Trends, Challenges and Future Business Growth by 2031
21 September 2023, Benzinga

CyberTech Systems and Software Limited: -September 21, 2023
21 September 2023, Marketscreener.com

Data takes Center Court at the Women's Tennis Association with ...
23 August 2023, WTA Tennis

SAP Evolves for Next-Gen Enterprises
18 May 2022, InformationWeek

AWS’ 7 New Cloud Storage Products; NetApp, Oracle, Cloudflare ...
19 September 2023, CRN

provided by Google News

SQLite 3.43 Released With Up To 2x Performance For JSON ...
24 August 2023, Phoronix

Mageia 9 Released With SQLite-Based RPM Package Database ...
27 August 2023, Phoronix

VB.NET SQL Examples for Querying Databases Efficiently - MUO
13 September 2023, MakeUseOf

RDBMS Software Market Competitive Analysis till 2031
20 September 2023, Benzinga

Two flaws in Apache SuperSet allow to remotely hack servers
7 September 2023, Security Affairs

provided by Google News

Job opportunities

SSIS/SQL Server Developer (Health Care) full time
PSRTEK, Remote

Senior SQL Server DBA (Hybrid remote)
UCLA Health, Los Angeles, CA

SQL Server DBA
ANB Sourcing LLC, Remote

SQL Server Database Administrator/Developer
North Carolina Dept of State Treasurer, Wake County, NC

SQL Server DBA
Agama Solutions, United States

SAP BW HANA Consultant
Trinity Technologies, Remote

SAP BW / HANA Consultant
Snaprecuit LLC, Remote

Sap S/4 Hana Architect 26523
Micro Solutions, Remote

SAP MDG S4 HANA - Remote
Mindzcape Solutions Inc, Dallas, TX

SAP S4 HANA - MM & Data migration
eTeam Inc., Foster City, CA

Application Technology Specialist – Lockbox
EverView, Remote

Data Engineer [USA - Remote]
AURA TECHNOLOGIES LLC., Chapel Hill, NC

Species Habitat Modeling Program Contractor (Remote)
NatureServe, Arlington, VA

Intermediate Game Programmer
Applied Research Associates, Inc, Raleigh, NC

windows app c++ developer
Cortrack Solutions Pvt Ltd., Remote

jobs by Indeed



Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Redis logo

The world’s most loved real‑time data platform.
Try free

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

SingleStore logo

Build AI apps with Vectors on SQL and JSON with milliseconds response times.
Try it today.

Present your product here