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, 2020 in Azure by anonymous
• 6,260 points
1,861 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).

Hope this helps!!

If you need to know more about Azure, then you should join Microsoft Azure certification course today.

Thank you!!

answered Jan 10, 2020 by Sirajul
• 59,230 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 11, 2018 in Azure by club_seesharp
• 3,450 points
1,097 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
• 58,090 points
13,646 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 9, 2018 in Azure by club_seesharp
• 3,450 points
6,490 views
0 votes
0 answers
0 votes
1 answer

What are azure functions? What is their use?

Azure Functions is a serverless computing service hosted ...READ MORE

answered Jan 10, 2020 in Azure by Sirajul
• 59,230 points

edited Jun 27, 2023 by Khan Sarfaraz 1,713 views
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, 2020 in Azure by Sirajul
• 59,230 points
1,237 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP