Please provide the cons and comparison between azure blob and azure sql
*This post is locked for comments
Hi,
Azure Blob is part of larger concept called Azure Storage which comprises of following four services: Blob storage, Table storage, Queue storage, and File storage. A storage account is a required for storing your unstructured data as blobs (objects) in Azure Storage.
Pricing: azure.microsoft.com/.../blobs
Azure SQL Database is a cloud database. Consider a scenario where you wana copy your CRM Online data (for better reporting requirements) then you can use tools like Microsoft Data Export Services or Scribe Online replication services to create a copy of your online DB onto your Azure SQL db. This will sync DBs as per set intervals as well. Azure SQL behaves exactly like onpremise DB only difference being data is residing in cloud.
Pricing: https://azure.microsoft.com/en-in/pricing/details/sql-database/
Hope this helps.
Regards,
Pranav
Here are a view inputs from stackoverflow...
stackoverflow.com/.../getting-started-with-azure-storage-blobs-vs-tables-vs-sql-azure
stackoverflow.com/.../when-should-i-use-sql-azure-and-when-should-i-use-table-storage
stackoverflow.com/.../azure-mvc-web-app-architecture-how-to-split-data-between-sql-azure-and-azure
André Arnaud de Cal...
291,969
Super User 2025 Season 1
Martin Dráb
230,842
Most Valuable Professional
nmaenpaa
101,156