什么是SQL Azure和SQL Server 2008的区别? [英] What is the difference between SQL Azure and SQL Server 2008?
问题描述
现在我期待在Azure上并要迁移这一点。但我不知道,不明白在这样一个问题。
你能解释的区别是什么?而我defenetly不能与SQL Azure的吗?
now I'm looking on Azure and want to migrate on this one. But I'm not sure that don't get a problems on this way. Could you explain what is the difference? And what I defenetly can't do with SQL Azure?
推荐答案
SQL Azure是SQL Server的子集
这意味着在SQL服务器的某些功能present不会在SQL Azure中present。
所以它有很多的不支持的功能
http://msdn.microsoft.com/en-us/library/ee336253.aspx
还有一些其他的限制
http://msdn.microsoft.com/en-us/library/ff394115.aspx
SQL Azure is a subset of SQL server.
That means some features present in SQL server won't be present in SQL Azure.
So it has a lot of unsupported features
http://msdn.microsoft.com/en-us/library/ee336253.aspx
And some other limitations
http://msdn.microsoft.com/en-us/library/ff394115.aspx
Azure不支持CLR存储过程(扩展存储过程既不)
<一href=\"https://feedback.azure.com/forums/217321-sql-database/suggestions/401015-support-clr-stored-procedures\" rel=\"nofollow\">https://feedback.azure.com/forums/217321-sql-database/suggestions/401015-support-clr-stored-procedures
而在一般的存储过程的支持是值得商榷
<一href=\"http://blogs.msdn.com/b/sajid/archive/2010/04/22/restrictions-of-stored-procedures-in-sql-azure.aspx\" rel=\"nofollow\">http://blogs.msdn.com/b/sajid/archive/2010/04/22/restrictions-of-stored-procedures-in-sql-azure.aspx
Azure does not support CLR stored procedures (extended stored procedures neither)
https://feedback.azure.com/forums/217321-sql-database/suggestions/401015-support-clr-stored-procedures
And stored procedure support in general is questionable
http://blogs.msdn.com/b/sajid/archive/2010/04/22/restrictions-of-stored-procedures-in-sql-azure.aspx
和它没有计划任务(或程序)
计划任务和Sql Azure的?
And it does not have scheduled tasks (or procedures)
Scheduled Tasks with Sql Azure?
它不支持全文索引或者
<一href=\"https://feedback.azure.com/forums/217321-sql-database/suggestions/405464-support-full-text-indexing\" rel=\"nofollow\">https://feedback.azure.com/forums/217321-sql-database/suggestions/405464-support-full-text-indexing
SQL Azure的 - 字符串搜索
你不能做跨数据库的参照线(不下去了,看的https://azure.microsoft.com/en-us/blog/querying-remote-databases-in-azure-sql-db/)
<一href=\"http://www.mygreatwindowsazureidea.com/forums/34685-sql-azure-feature-voting/suggestions/402636-cross-database-reference?ref=title\" rel=\"nofollow\">http://www.mygreatwindowsazureidea.com/forums/34685-sql-azure-feature-voting/suggestions/402636-cross-database-reference?ref=title
空间数据支持缺失以及(不再)
的http://www.keepitsimpleandfast.com/2009/12/main-differences-between-sql-azure-and.html
You can't do cross-database referencing (not anymore, see https://azure.microsoft.com/en-us/blog/querying-remote-databases-in-azure-sql-db/)
http://www.mygreatwindowsazureidea.com/forums/34685-sql-azure-feature-voting/suggestions/402636-cross-database-reference?ref=title
Spatial data support is missing as well (not anymore)
http://www.keepitsimpleandfast.com/2009/12/main-differences-between-sql-azure-and.html
它不支持FILESTREAM
<一href=\"https://feedback.azure.com/forums/217321-sql-database/suggestions/413287-implement-filestream-for-blobs-into-azure-blob-sto\" rel=\"nofollow\">https://feedback.azure.com/forums/217321-sql-database/suggestions/413287-implement-filestream-for-blobs-into-azure-blob-sto
没有探查的SQL蔚蓝
<一href=\"https://feedback.azure.com/forums/217321-sql-database/suggestions/431943-profiler-for-sql-azure\" rel=\"nofollow\">https://feedback.azure.com/forums/217321-sql-database/suggestions/431943-profiler-for-sql-azure
该数据库将不能自动增加它的最大允许大小
<一href=\"http://stackoverflow.com/questions/3254630/sql-azure-what-will-happen-if-size-of-my-sql-azure-get-5gb\">SQL Azure的:如果我的SQL Azure的大小获得5GB会发生什么事
It doesn't support filestream
https://feedback.azure.com/forums/217321-sql-database/suggestions/413287-implement-filestream-for-blobs-into-azure-blob-sto
There is no profiler for SQL azure
https://feedback.azure.com/forums/217321-sql-database/suggestions/431943-profiler-for-sql-azure
The database won't automagically increase it's max allowed size
SQL Azure: What will happen if size of my SQL Azure get 5GB?
和存在的SSMS没有完全支持
<一href=\"http://www.mygreatwindowsazureidea.com/forums/34685-sql-azure-feature-voting/suggestions/476408-full-management-studio-support?ref=title\" rel=\"nofollow\">http://www.mygreatwindowsazureidea.com/forums/34685-sql-azure-feature-voting/suggestions/476408-full-management-studio-support?ref=title
And there is no full support for SSMS
http://www.mygreatwindowsazureidea.com/forums/34685-sql-azure-feature-voting/suggestions/476408-full-management-studio-support?ref=title
它不支持ASP.NET会话(不再,但你需要您的会话班,Serializable属性标记)
<一href=\"http://www.mygreatwindowsazureidea.com/forums/34685-sql-azure-feature-voting/suggestions/472024-add-support-for-asp-net-sessions-in-sql-azure?ref=title\" rel=\"nofollow\">http://www.mygreatwindowsazureidea.com/forums/34685-sql-azure-feature-voting/suggestions/472024-add-support-for-asp-net-sessions-in-sql-azure?ref=title
那么,有没有办法发送电子邮件
从SQL蔚蓝发送电子邮件
这是你如何与它连接,使用SSMS:
http://www.mssqltips.com/tip.asp?tip=1950
It doesn't support ASP.NET sessions (not anymore, but you need to mark your session classes with the Serializable attribute)
http://www.mygreatwindowsazureidea.com/forums/34685-sql-azure-feature-voting/suggestions/472024-add-support-for-asp-net-sessions-in-sql-azure?ref=title
Then, there is no way to send emails
sending email from sql azure
This is how you connect to it, using SSMS:
http://www.mssqltips.com/tip.asp?tip=1950
附录:它不是可能有一个数据库大于 150 1000 GB
(每2014年03月500 GB)
(GB 1000 2016年每19日)
<一href=\"http://stackoverflow.com/questions/12394831/overcoming-windows-azure-sql-database-150-gb-size-limitation\">Overcoming Windows Azure的SQL数据库150 GB大小的限制
Addendum: And it's not possible to have a database larger than 150 1000 GB
(500 GB per 03. April 2014)
(1000 GB per 19. February 2016)
Overcoming Windows Azure Sql Database 150 gb size limitation
而且它的成本模型是'阴天'充其量
http://www.microsoft.com/windowsazure/pricing/
的http://searchwindevelopment.techtarget.com/news/1507649/Windows-Azures-hidden-compute-costs
<一href=\"http://stackoverflow.com/questions/4314054/real-world-windows-azure-costing-examples-anyone/7076651#7076651\">Real世界Windows Azure的成本计算的例子,有人吗?
的http://www.brentozar.com/archive/2009/07/sql-azure-pricing-10-for-1gb-100-for-10gb/
忘了说了9.99的价值,这不是事实。
这只是租金为数据 - 你还需要租用休息
。
Azure的定价很复杂
和至少80 $一个月。
http://www.microsoft.com/windowsazure/pricing-calculator/
在一年的时间,这是960 $你花租用(mimimum,你不会有太多这样)。
And it's cost model is 'cloudy' at best
http://www.microsoft.com/windowsazure/pricing/
http://searchwindevelopment.techtarget.com/news/1507649/Windows-Azures-hidden-compute-costs
Real World Windows Azure Costing Examples, Anyone?
http://www.brentozar.com/archive/2009/07/sql-azure-pricing-10-for-1gb-100-for-10gb/
Forget that 9.99 value, it's not the truth.
It's only the rent for the data - you also need to rent the rest.
Azure's pricing is complicated
And at least 80$ a month.
http://www.microsoft.com/windowsazure/pricing-calculator/
On a year, that's 960 $ you spend on renting (mimimum, and you won't have too much for this).
基本上,只要浏览本:
http://www.mygreatwindowsazureidea.com/forums/34685-sql-azure -feature投票
和这个
<一href=\"http://stackoverflow.com/search?page=2&tab=relevance&q=sql%20azure%20unsupported\">http://stackoverflow.com/search?page=2&tab=relevance&q=sql%20azure%20unsupported
对于相关问题的快速参考。
Basically, just browse this:
http://www.mygreatwindowsazureidea.com/forums/34685-sql-azure-feature-voting
and this
http://stackoverflow.com/search?page=2&tab=relevance&q=sql%20azure%20unsupported
for a quick reference of the related problems.
没关系,你存储您(或您的客户)别人的服务器上的敏感数据
(税收,专利申请,报价,客户名单,数据库模式,等等)。
Never mind that you store your (or your customers) sensitive data on someone else's server (taxation, patent filings, offers, customer lists, your database schema, etc.).
这篇关于什么是SQL Azure和SQL Server 2008的区别?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!