MongoDB vs. SQL Server

The MongoDB store the data in documents with JSON format but SQL store the data in Table format.

The MongoDB provides high performance, high availability, easy scalability etc. rather than SQL Server.

MongoDB mentioned to document-based NoSQL databases but SQL Server mentioned to relational database.

MongoDB is a NoSQL database so there's nothing like a stored procedure. You can create a set of common functionality in a class library.

The "fire-and-forget" is a default option to check query operations but we can use to "getLastError" method to check query operations succeeded or not.

In the MongoDB, we can change the structure simply by adding, removing column from the existing documents.

For SQL Server to MongoDB mapping chart, go to live link https://docs.mongodb.org/manual/reference/sql-comparison/

For more detail, go to below link.

http://stackoverflow.com/questions/13190468/pros-and-cons-of-using-mongodb-instead-of-ms-sql-server

Pin it

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2

MongoDB vs. SQL Server

Reviewed by Anil Singh on 9:10 PM Rating: (5)