Please provide the cons and comparison between azure blob and azure sql
*This post is locked for comments
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
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
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Community Member 2
HR-09070029-0 2
UllrSki 2
