| SQL Server | Mongo DB |
| Microsoft product | Mongo DB product |
| For commercial | Open source |
| Works on windows | Works on Windows, Linux, OS X, Solaris |
| Scalable vertically | Scalable horizontally |
| SQL query language | JSON query language |
| Database | Database |
| Fixed Schema | Dynamic Schema |
| Table | Collection |
| Row | document or BSON document |
| Column | Field |
| Index | Index |
| Primary key | Primary key |
| Foreign keys | No foreign keys |
| Joins | Embedded document and linking |
| Triggers | No triggers available |
Thursday, 12 November 2015
SQL Server Vs MongoDB
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment