Azure的SQL数据库Web VS商业版 [英] Azure SQL Database Web vs Business Edition

问题描述

有网络版，比支持的最大的数据库大小Azure的SQL数据库其他的商业版有什么区别？我假设的命名有一定的意义，但所有的信息，我觉得单纯是最大分贝大小会谈。我想知道，如果有任何其他方面的差异，如SLA，复制，可扩展性等。

Is there any difference between the Web Edition and Business Edition of Azure SQL Database other than the maximum supported database sizes? I'm assuming the naming has some significance but all of the information I find simply talks about the max db size. I want to know if there are any other differences such as SLA, replication, scalability, etc.

任何线索？

推荐答案

这两个版本相同，只是容量相同。两者都提供相同的复制和SLA。

The two editions are identical except for capacity. Both offer the same replication and SLA.

修改2014年4月3日 - 更新，以反映目前的SQL数据库大小限制在500GB

修改2013年6月17日：自从我最初发布这个答案，几件事情都与价格变化（但尺寸仍然是网络与放大器之间的唯一区别;企业版）

网络版扩展到5GB，而商业版扩展到500GB。另外：新的MSDN计划（在TechEd 2013公布;见ScottGu的<一个href=\"http://weblogs.asp.net/scottgu/archive/2013/06/03/windows-azure-announcing-major-improvements-for-dev-test-in-the-cloud.aspx\"相对=nofollow>博客文章了解更多详细信息），你现在会得到对你想你的学分适用于任何服务月度货币信贷，包括SQL数据库（高达$ 150元不等，根据MSDN层 - 请参见此页面为各地新MSDN细节好处）。

Web Edition scales to 5GB, whereas Business Edition scales to 500GB. Also: with the new MSDN plans (announced at TechEd 2013; see ScottGu's blog post for more details), you'll now get monthly monetary credits toward any services you want to apply your credits to, including SQL Database (up to $150 per month, depending on MSDN tier - see this page for details around the new MSDN benefits).

两者都允许您设置最大尺寸，两者都在摊销的时间表，你的能力每日计算收费。全部定价细节这里。你会看到，基​​本价为$ 49.95开始（最大100MB），然后跳转至$ 9.99（最大1GB），然后开始分层定价额外GB的。

Both allow you to set maximum size, and both are billed on an amortized schedule, where your capacity is evaluated daily. Full pricing details are here. You'll see that the base pricing begins at $4.995 (up to 100MB), then jumps to $9.99 (up to 1GB), and then starts tiered pricing for additional GB's.

不管版本，你有相同的特性 - 它是所有关于容量限制。你可以很容易地改变最大容量，甚至改变版，用T-SQL。例如，您可以与Web版启动：

Regardless of edition, you have the exact same set of features - it's all about capacity limits. You can easily change maximum capacity, or even change edition, with T-SQL. For instance, you might start with a Web edition:

CREATE DATABASE Test (EDITION='WEB', MAXSIZE=1GB)

您需求的增长，让你一下子提高到5GB：

Your needs grow, so you bump up to 5GB:

   ALTER DATABASE Test MODIFY (EDITION='WEB', MAXSIZE=5GB)

现在，你需要更多的容量，所以你需要切换到商业版层级之一：

Now you need even more capacity, so you need to switch to one of the Business Edition tiers:

ALTER DATABASE Test MODIFY (EDITION='BUSINESS', MAXSIZE=10GB)

如果你需要减少你的数据库的大小，这工作也很不错 - 只是改变右后卫网络版：

If you ever need to reduce your database size, that works just fine as well - just alter right back to Web edition:

ALTER DATABASE Test MODIFY (EDITION='WEB', MAXSIZE=5GB)

这篇关于Azure的SQL数据库Web VS商业版的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！