DBMS > Microsoft SQL Server vs. MongoDB vs. searchxml
System Properties Comparison Microsoft SQL Server vs. MongoDB vs. searchxml
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Microsoft SQL Server Xexclude from comparison||MongoDB Xexclude from comparison||searchxml Xexclude from comparison|
|Description||Microsofts relational DBMS||One of the most popular document stores available both as a fully managed cloud service and for deployment on self-managed infrastructure||DBMS for structured and unstructured content wrapped with an application server|
|Primary database model||Relational DBMS||Document store||Native XML DBMS|
|Secondary database models||Document store|
|Search engine integrated Lucene index, currently in MongoDB Atlas only.|
|Developer||Microsoft||MongoDB, Inc||informationpartners gmbh|
|Current release||SQL Server 2019, November 2019||4.2, August 2019||1.0|
|License Commercial or Open Source||commercial restricted free version is available||Open Source MongoDB Inc.'s Server Side Public License v1. Prior versions were published under GNU AGPL v3.0. Commercial licenses are also available.||commercial|
|Cloud-based only Only available as a cloud service||no||no MongoDB available as DBaaS (MongoDB Atlas)||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|MongoDB Atlas: Deploy a fully managed cloud database on-demand and ready for use in minutes. Available on AWS, Azure, and GCP.|
|Server operating systems||Linux|
|Data scheme||yes||schema-free Although schema-free, documents of the same collection often follow the same structure. Optionally impose all or part of a schema by defining a JSON schema.||schema-free|
|Typing predefined data types such as float or date||yes||yes string, integer, double, decimal, boolean, date, object_id, geospatial||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.||yes||yes|
|SQL Support of SQL||yes||Read-only SQL queries via the MongoDB Connector for BI||no|
|APIs and other access methods||ADO.NET|
Tabular Data Stream (TDS)
|proprietary protocol using JSON||RESTful HTTP API|
|Supported programming languages||C#|
|Actionscript inofficial driver|
Clojure inofficial driver
ColdFusion inofficial driver
D inofficial driver
Dart inofficial driver
Delphi inofficial driver
Groovy inofficial driver
Lisp inofficial driver
Lua inofficial driver
MatLab inofficial driver
PowerShell inofficial driver
Prolog inofficial driver
R inofficial driver
Smalltalk inofficial driver
|C++ most other programming languages supported via APIs|
|Triggers||yes||yes in MongoDB Atlas only||no|
|Partitioning methods Methods for storing different data on different nodes||tables can be distributed across several files (horizontal partitioning); sharding through federation||Sharding partitioned by hashed, ranged, or zoned sharding keys||none|
|Replication methods Methods for redundantly storing data on multiple nodes||yes, but depending on the SQL-Server Edition||Master-slave replication||yes sychronisation to multiple collections|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||yes||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Eventual Consistency|
Immediate Consistency can be individually decided for each write operation
|Foreign keys Referential integrity||yes||no typically not used, however similar functionality with DBRef possible||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||Multi-document ACID Transactions with snapshot isolation||multiple readers, single writer|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes||yes optional||yes|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||yes||yes In-memory storage engine introduced with MongoDB version 3.2||no|
|User concepts Access control||fine grained access rights according to SQL-standard||Access rights for users and roles||Domain, group and role-based access control at the document level and for application services|
|More information provided by the system vendor|
|Microsoft SQL Server||MongoDB||searchxml|
|Specific characteristics||MongoDB is the leading modern, general purpose data platform, designed to unleash...|
|Competitive advantages||The MongoDB Data Platform can be used by developers building OLTP and analytical...|
|Typical application scenarios||Internet of Things and Time Series (Bosch, Jaguar Land Rover) Mobile (The Weather...|
|Key customers||ADP, Adobe, Amadeus, AstraZeneca, Auto Trader, Barclays, BBVA, Bosch, Cisco, CERN,...|
|Market metrics||70 million downloads (growing at more than 30 thousand downloads per day). 15,000+...|
|Licensing and pricing models||MongoDB database server: Server-Side Public License (SSPL) . Commercial licenses...|
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||DBHawk is a web-based data management Tool for a SQL Server database.|
Navicat Monitor is a safe, simple and agentless remote server monitoring tool for SQL Server and many other database management systems.
SQLPro for MSSQL: A simple but powerful Microsoft SQL Server database client available on iPhone and iPad as well as macOS.
Navicat for SQL Server gives you a fully graphical approach to database management and development.
General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
ERBuilder provides all the features you would expect from a professional database modeling and design tool.
Dremio is like magic for SQL Server accelerating your analytical queries up to 1,000x.
|DBHawk: Powerful web-based MongoDB GUI. Connect securely to on-premise MongoDB or MongoDB on the Cloud, Atlas or mLab.|
Knowi: Build MongoDB Reports and Data Visualizations in Minutes with Native Integration
ScaleGrid: Deploy, monitor, backup and scale MongoDB in the cloud with the #1 Database-as-a-Service (DBaaS) platform.
Studio 3T: The world's favorite IDE for working with MongoDB
Navicat for MongoDB gives you a highly effective GUI interface for MongoDB database management, administration and development.
CData: Connect to Big Data & NoSQL through standard Drivers.
Dremio: Analyze your data with standard SQL and any BI tool. Accelerate your queries up to 1,000x.
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|Microsoft SQL Server||MongoDB||searchxml|
|DB-Engines blog posts|
The struggle for the hegemony in Oracle's database empire Microsoft SQL Server is the DBMS of the Year Architecting eCommerce Platforms for Zero Downtime on Black Friday and Beyond
Microsoft SQL Server is the DBMS of the Year Architecting eCommerce Platforms for Zero Downtime on Black Friday and Beyond
Architecting eCommerce Platforms for Zero Downtime on Black Friday and Beyond
PostgreSQL is the DBMS of the Year 2018 PostgreSQL moves up one rank at the expense of MongoDB
PostgreSQL moves up one rank at the expense of MongoDB
|Recent citations in the news|
IDERA SQL Diagnostic Manager for SQL Server 10.5 Expands Performance Monitoring On-Premises and in the Cloud
SQL Server 2008's End of Life Opens New Role for Database as a Service
SQL Server Runs Faster on Azure Cloud VMs than AWS EC2, Report Says
SQL Server 2019 Licensing: How Much Does It Cost and What's Included?
Transform Data Into Game-Changing Insights with This SQL Training
provided by Google News
MongoDB (MDB) to Report Q3 Earnings: What's in the Offing?
Is MongoDB, Inc. (MDB) A Good Stock To Buy?
MongoDB Atlas Adds Support for AWS CloudFormation, and EventBridge
Secret CSO: Lena Smart, MongoDB
Will MongoDB (MDB) Report Negative Earnings Next Week? What You Should Know
provided by Google News
Senior SQL Server Database Administrator
SQL and Reporting Developer
Full Stack Developer - Data Science
Full Stack Developer
Full Stack Developer - Transaction Banking
Share this page