Base Of Difference | MongoDB | MS SQL Server |
XML Support | MongoDB will not support XML | SQL Server support XML |
Script | MongoDB support Javascript | MS SQL support Transact SQL and .NET languages |
Release Year | 2009 | 1989 |
Storage Model | MongoDB support Document-oriented storage model | Storage model support by MS SQL Server is RDBMS |
Transaction Type | NO | SQL Server support ACID transaction type |
Joins | MongoDB does not support Join | SQL Server support joins |
Map Reduce | MongoDB support Map Reduce | SQL Server doesnot support Map Reduce |
Language | MongoDB support JSON Query Language | SQL Query Language |
Scalability | MongoDB support Horizontal Scalability | SQL Server scalability is vertical |
Agile | MongoDB support Agile practices | SQL Server doesnot support agile practice |
Data Schema | There is dynamic Data Schema in MongoDB | Data schema in SQL Server is fixed |
Licence | MongoDB is open source | MS SQL Server licence is commercial |
Language of Implementation | MongoDB implementation is C++ | SQL Server implementation language is C++ |
Name of Company | Company name is MongoDB.INC | SQL Server company name is Microsoft |
Foreign Key | There is no concept of foreign key in MongoDB | SQL Server support foreign keys concept |
Concurrency | MongoDB doesnot support concurrency | SQL Server support consurrency |
Triggers | MongoDB not support Triggers | SQl Server Support triggers |
Secondary Index | MongoDB support secondary index | SQL Server support secondary index |
Operating System | MongoDB support by different operating systems like Windows, Linux and OS X. | SQL Server support operating system like windows. |
Drivers | Supports driver MongoDB are Dart, Delphi, Erlang, Go, Groovy, Haskell, Java, JavaScript, Lisp, Lua, MatLab, Perl, PHP, PowerShell, Prolog, Python, R, Ruby, Scala, Smalltalk | Different drivers support SQL Server are .NET, Java, PHP, Python, Ruby, Visual Basic |