什么是SQL Azure和SQL Server 2008的区别? [英] What is the difference between SQL Azure and SQL Server 2008?

查看:202
本文介绍了什么是SQL Azure和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屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆