locked
Azure Tables or SQL Azure? RRS feed

  • Question

  • I am at the planning stage of a web application that will be hosted in Azure with ASP.NET for the web site and Silverlight within the site for a rich user experience. Should I use Azure Tables or SQL Azure for storing my application data?
    Saturday, November 22, 2014 5:50 AM

Answers

  • Hi Carol,

    Before we choose the Azure Table Or SQL Azure for storing  data, we  need to know their  differences and

    Scenarios:

    First ,Azure SQL Database is a relational database service that extends core SQL Server capabilities to the cloud.

    While  Azure Table Storage is a fault-tolerant, ISO 27001 certified NoSQL key-value store. It stores structured data   without schemas, it does not provide any way to represent relationships between the data.

    Second, If your application stores and retrieves large data sets that do not require rich relational capabilities, Azure Table Storage might be a better choice. If your application requires data processing over schematized data sets and is relational in nature, Azure SQL Database might better suit your needs.

    In fact There are  several other  of  factors you should consider when choose which one to store data ,please refer to the links below for more information:

    http://msdn.microsoft.com/en-us/library/azure/jj553018.aspx

    http://msdn.microsoft.com/en-us/magazine/gg309178.aspx

    Best Regards,

    Kevin Shen.

    • Proposed as answer by Alan Smith MVPMVP Monday, November 24, 2014 9:22 AM
    • Marked as answer by Mekh Subba Thursday, November 27, 2014 7:29 AM
    Monday, November 24, 2014 7:23 AM

All replies

    • Proposed as answer by Mekh Subba Thursday, November 27, 2014 7:29 AM
    Saturday, November 22, 2014 7:14 AM
  • Hi Carol,

    Before we choose the Azure Table Or SQL Azure for storing  data, we  need to know their  differences and

    Scenarios:

    First ,Azure SQL Database is a relational database service that extends core SQL Server capabilities to the cloud.

    While  Azure Table Storage is a fault-tolerant, ISO 27001 certified NoSQL key-value store. It stores structured data   without schemas, it does not provide any way to represent relationships between the data.

    Second, If your application stores and retrieves large data sets that do not require rich relational capabilities, Azure Table Storage might be a better choice. If your application requires data processing over schematized data sets and is relational in nature, Azure SQL Database might better suit your needs.

    In fact There are  several other  of  factors you should consider when choose which one to store data ,please refer to the links below for more information:

    http://msdn.microsoft.com/en-us/library/azure/jj553018.aspx

    http://msdn.microsoft.com/en-us/magazine/gg309178.aspx

    Best Regards,

    Kevin Shen.

    • Proposed as answer by Alan Smith MVPMVP Monday, November 24, 2014 9:22 AM
    • Marked as answer by Mekh Subba Thursday, November 27, 2014 7:29 AM
    Monday, November 24, 2014 7:23 AM
  • SQL Azure is great when you want to work with structured data using relations, indexes, constraints, etc. Azure storage table is great when you need to work with centralized structured data without relations and usually with large volumes

    SQL Azure is great when you want to work with structured data using relations, indexes, constraints, etc.

    Azure storage table is great when you need to work with centralized structured data without relations and usually with large volumes.

    The Price: SQL Azure: $25.98/mo for 5GB

    Storage table: $21.88/m for 175 GB (without transactions or bandwidth) So when you store large volumes of data, storage table is a lot cheaper... think of logging for example.

    The centralization: Windows Azure is a distributed environment for windows virtual server so if you save something on one machine, others won't know about it, therefore storage table is a good solution for centralized loggins, session handling, settings or whatever (keep on mind that there is latency even in one datacenter)

    The speed: If you design it right, in many cases storage table should be faster than sql azure but it probably depends on use cases and I haven't really tested this.
    Tuesday, May 19, 2020 2:21 PM