Table vs SQL Azure
-
vendredi 15 juin 2012 14:54
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
Toutes les réponses
-
vendredi 15 juin 2012 15:03
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 -
vendredi 15 juin 2012 17:49Modérateur
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:
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 )

