Difference between MS SQL Server and MongoDB

1. MS SQL Server :
Microsoft SQL Server is a relational database management system (RDBMS) which is platform dependent and it is both GUI and command based software. It supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments. It was developed by Microsoft Corporation and initially released on April 24, 1989. It is written in C and C++ language.

2. MongoDB :
MongoDB is a cross-platform document-oriented and a non relational (i.e., NoSQL) database program. It is an open-source document database, that stores the data in the form of key-value pairs. MongoDB is developed by MongoDB Inc. and initially released on 11 February 2009. It is written in C++, Go, JavaScript, Python language. MongoDB offers high speed, high availability, and high scalability.



Difference between MS SQL Server and MongoDB :

S.NO. MS SQL server Mongodb
1. Developed by Microsoft Corporation and initially released on April 24, 1989. Developed by MongoDB Inc. and initially released on 11 February 2009.
2. MS SQL server is written in C and C++. MongoDB is written in C++, Go, JavaScript, Python languages.
3. The primary database model for MS SQL Server is Relational DBMS The primary database model for MongoDB is Document store.
4. The license for MS SQL Server is Commercial. The license for MongoDB is Open Sourse.
5. MS SQL Server supports XML data format. MongoDB does not supports XML data format.
6. MS SQL Server provides ACID transactions without snapshot isolation. MongoDB provides Multi-document ACID transactions with snapshot isolation.
7. In MS SQL Server the data schema is Fixed. In MongoDB the data schema is Dynamic.
8. MS SQL Server provides the concept of Referential Integrity and have Foreign keys. MongoDB does not provides the concept of Referential Integrity. Hence no Foreign Keys.
9. MS SQL Server does not supports Map Reduce method. MongoDB supports Map Reduce method.
10. Server operating systems for MS SQL Server are Linux Windows. Server operating systems for MongoDB are Solaris, Linux, OS X, Windows.
11. Famous companies like Citi, Bank of America, UPS, etc uses MS SQL Server. Famous companies like Adobe, Amadeus, Lyft, ViaVarejo, Craftbase, etc uses MongoDB.

Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.

My Personal Notes arrow_drop_up


If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.


Article Tags :
Practice Tags :


Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.