Table vs SQL Azure

Question

Hi All,

I just read some article about azure from https://www.windowsazure.com/en-us/develop/net/fundamentals/intro-to-windows-azure/

I'm confuse about data management inside.About Table and SQL Azure.However on SQL Azure as database surely include table.So, what different between SQL Azure and Table in that article?

Anyone could tell me more about it ?

Thanks

Answer 1

Hello,

You can't really compare a RDBMS table with Windows Azure Storage table.

A Win Azure table is more like NoSql, see MSDN Article Windows Azure Table Storage – Not Your Father’s Database

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

As OLAF helper said SQL Azure is RDBMS and Storage Tables is more like NoSQL. That just means that if you do NOT need RDBMS like features such as Joins, better query options, run complex queries, federations, sql azure reporting then you can see if Azure Tables fits your need. I have one more resource for you: SQL Azure and WIndows Azure Table Storage

And Similar Forum threads:

http://social.msdn.microsoft.com/Forums/en-US/windowsazuredata/thread/e4f79cf6-4ad0-4ca8-9c80-df2dab0cf599

http://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/880e56cb-33d8-4eda-8805-239bf629c519

Note:

In your research, you will read that "Azure Tables is cheaper" - I Just want you to know that may not be the case always because there is "per-transaction" fee which is not applicable when you go for SQL Azure based solutions. Please consider that too.

Sorry for pointing to lot of resources, it's just that without knowing what you are trying to accomplish - it's not possible to answer in a way that completely answers your questions. Though, in your research if you have any questions you could always come back and ask other questions.

---

Paras Doshi (Blog: ParasDoshi.com | Twitter: @Paras_Doshi )