Microsoft Azure Cosmos DB vs Microsoft Azure SQL Database [closed] Microsoft Azure Cosmos DB vs Microsoft Azure SQL Database [closed] database database

Microsoft Azure Cosmos DB vs Microsoft Azure SQL Database [closed]


Azure Cosmos DB is a non-SQL database that provides access to information (JSON) quickly, with high availability, scalable and with global replication.

Microsoft Azure SQL Database as a Service offering with high compatibility to Microsoft SQL Server.That is, a Relational DBMS.

In your case it would be more convenient to use Cosmos DB because you can access the data (via JSON) without having to create a web service. And it have limitless scale. Your Azure Cosmos DB collections grow as your app grows. You can start with small data size and throughput of hundreds of requests per second.

Instead with Azure Database SQL you would have to create an ASP.Net Web API project to be able to access the data. (This could affect development time).

However, if you are not familiar with Cosmos DB it can affect development time as well.

You can find some examples here: