none
Storage account vs SQL Database

    Question

  • Hi,

    I am new to Azure and I want to ask is Storage account and alternative for SQL Databse? because it seems you can create tables and fields in Storage account as well.

    Kindly advise..

    Thanks,

    Jassim


    Sunday, March 5, 2017 10:47 PM

All replies

  • Azure storage offers a few different services, one of which is Table Storage, this is a simple NOSQL Key/Attribute store. So if you just want to store lots of unrelated data in tabular form then you can use this.

    However, if you need relationships and any of the other features of MS SQL then you need to look at Azure SQL. Similarly if you need more advanced NoSQL features you may wish to look at DocumentDB.


    Sam Cogan Microsoft Azure MVP
    Blog | Twitter

    Sunday, March 5, 2017 11:22 PM
  • There are many differences between Azure Storage tables and (both relational and non-relational) databases. This goes beyond data structure alone - and includes, for example, server side processing and vastly different indexing approaches (Azure Storage table supports a single clustered index based on the partition and raw keys). As the result, you should consider carefully what type of data you intend to store and what type of data processing/querying you intend to apply. For more info, refer to https://docs.microsoft.com/en-us/azure/documentdb/documentdb-nosql-vs-sql

    hth
    Marcin

    Sunday, March 5, 2017 11:43 PM
  • The short answer to your question is "YES", an Azure Storage account could be an alternative to SQL Azure.  However,  please consider what the prior posters have written and know that there are significant differences and you need to decide whether your situation is better suited for Storage or SQL.

    There is lots of detailed information available on this topic.  A quick Google search can yield helpful results.


    SOTATS, Inc.

    Sunday, March 5, 2017 11:56 PM