Different between the azure table storage and the azure sql service
Loading
Different between the azure table storage and the azure sql service
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Brahma Prakash ShuklaPosted Nov 6, 2022, 7:06 AM
https://stackoverflow.com/questions/10257872/azure-storage-tables-vs-sql#:~:text=SQL%20Azure%20is%20great%20when,and%20usually%20with%20large%20volumes.
Ijas AhamedPosted Oct 22, 2022, 1:28 PM
There is a fundamental difference between a SQL table and Azure table. While azure tables are capable of storing one type of data in a row and another type of data in an another row, SQL database tables are designed to store the same type of data in each and every row.
Rijwan AnsariPosted Oct 22, 2022, 11:58 AM
HI,
Azure Table is a type of Azure Storage service that allows you to store structured NoSQL data in the cloud, providing a key/attribute store with a schemaless design.
You want to store flexible datasets like user data for web applications, address books, device information, or other types of metadata your service requires. Example: Azure Cosmos DB
For more details: https://learn.microsoft.com/en-us/azure/storage/common/storage-introduction
Azure SQL Service
You can use Azure SQL Database.
Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement. Azure SQL Database is always running on the latest stable version of the SQL Server database engine and patched OS with 99.99% availability. PaaS capabilities built into Azure SQL Database enable you to focus on the domain-specific database administration and optimization activities that are critical for your business.
This is similar to SQL Server on Azure Cloud.
https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview?view=azuresql