| 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 |