Clever Geek Handbook

Multi-user application on Windows Azure

We want to create a multi-user application with a common database table structure.

Currently, with standard SQL Server, we can achieve this by providing a TenantID for each table.

Is it possible to achieve the same result in Windows Azure, but without the TenantID?

Best regards, Alexey Zakharov

+1


source to share


3 answers


The question was about something else. I want to know if Azure SQL provides a schema multihomed database as a feature. - Alexey Zakharov on May 21 at 6:00



The short answer is that it is not. SQl Azure is essentially (a large subset of) SQL Server.

0


source


I would think you would want to do the same (use the TenantID column in SQL Azure or Windows Azure tables).



+2


source


I agree with the answer smarx gave you, but also consider this: if you have multiple tenants and this takes you to the SQL Azure size limit (say 1GB or 10GB), you will need to go to the next-large base data, and this can increase your costs beyond what you want:

  • 1GB: $ 10 per month
  • 10GB: $ 100 per month
  • 50GB: Released in June, presumably 5x10GB worth

So, in case you are under the 1GB limit with one tenant, but more than 1GB with say 2-5 tenants, it would be more economical to create separate 1GB databases for each tenant and then manage that shard in your business level based on TenantID.

+2


source






More articles:


All Articles