Need advice about which tool to choose?Ask the StackShare community!
Azure Cosmos DB vs Azure SQL Database: What are the differences?
What is Azure Cosmos DB? A fully-managed, globally distributed NoSQL database service. Azure DocumentDB is a fully managed NoSQL database service built for fast and predictable performance, high availability, elastic scaling, global distribution, and ease of development.
What is Azure SQL Database? Managed, intelligent SQL in the cloud. It is the intelligent, scalable, cloud database service that provides the broadest SQL Server engine compatibility and up to a 212% return on investment. It is a database service that can quickly and efficiently scale to meet demand, is automatically highly available, and supports a variety of third party software.
Azure Cosmos DB can be classified as a tool in the "NoSQL Database as a Service" category, while Azure SQL Database is grouped under "Databases".
Pros of Azure Cosmos DB
- Best-of-breed NoSQL features28
- High scalability22
- Globally distributed15
- Automatic indexing over flexible json data model14
- Tunable consistency10
- Always on with 99.99% availability sla10
- Javascript language integrated transactions and queries7
- Predictable performance6
- High performance5
- Analytics Store5
- Rapid Development2
- No Sql2
- Auto Indexing2
- Ease of use2
Pros of Azure SQL Database
- Managed6
- Secure4
- Scalable3
Sign up to add or upvote prosMake informed product decisions
Cons of Azure Cosmos DB
- Pricing17
- Poor No SQL query support4