How is Azure Cosmos db different from an Azure SQL db?

0 votes

I am developing a web app that also has to access information held in an online server at any moment from the user's device. I am planning to use the SQL database for this purpose but came across cosmos DB as an option for this. Can somebody explain how exactly the Cosmos database is different from Azure's SQL database? And which would be a better choice/option for a small web app?

Jan 10 in Azure by anonymous
• 5,330 points
215 views

1 answer to this question.

0 votes

Azure Cosmos DB is Microsoft’s globally distributed database service. The service is intended to allow customers to elastically (and independently) scale throughput and storage across any number of countries.

Azure Cosmos DB is a non-SQL database that gives 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 my opinion, it would be more convenient to use Cosmos DB because you'll be able to access the info (via JSON) without having to create a web service. And it would have limitless scale. One important thing about Azure Cosmos DB is that its collections grow as your app grows. You can start with small data size and throughput of many 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).

answered Jan 10 by Sirajul
• 48,960 points

Related Questions In Azure

0 votes
1 answer

How different is Web job from Worker role?

Some of the basic yet valid differences ...READ MORE

answered May 10, 2018 in Azure by club_seesharp
• 3,450 points
50 views
0 votes
2 answers

How can I download a .vhd image to my local machine from azure and upload the same to a different azure account?

From the Windows Azure Portal you can ...READ MORE

answered Aug 20, 2018 in Azure by Priyaj
• 57,530 points
4,740 views
0 votes
1 answer

How can we connect Azure Web App to an Azure SQL Database?

Its easy now! Go to your Azure SQL ...READ MORE

answered Aug 8, 2018 in Azure by club_seesharp
• 3,450 points
749 views
0 votes
0 answers
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

What is Azure SQL database? How to connect to Azure SQL database?

Azure SQL Database is a general-purpose relational ...READ MORE

answered Jan 13 in Azure by Sirajul
• 48,960 points
95 views
0 votes
1 answer