是否有当前版本的 SQL Azure 和 SQL Server 2008 之间差异的明确列表？
对于 SQL Azure，我是一个相对新手！我想知道在 SQL Server 2008 方面是否有关于 SQL Azure 支持和不支持哪些内容的明确列表？我已经通过谷歌浏览过，但我注意到一些博客文章缺少我通过自己的测试发现的东西：
例如，这个博客条目http://www.keepitsimpleandfast.com/2009/12/main-differences- Between -sql-azure-and.html
- 公共语言运行时 (CLR)
- 数据库文件放置
- 数据库镜像
- 分布式查询
- 分布式事务
- 管理
- 全局临时表
- 空间数据和索引
- SQL Server 配置选项
- SQL Server Service Broker
- 系统表
- 跟踪标志
文件组 重复 MSDN 页面 http://msdn.microsoft.com/en- us/library/ff394115.aspx
我从自己的测试中注意到，从 SQL Server 2008 迁移到 Azure 时，以下内容似乎存在问题：
- XML 类型（msdn 确实提到了大型自定义类型 - 我猜是这样）可能包括这个？？即使数据架构真的很小？）
- 多部分视图
我一直在使用的 SQL Azure 迁移向导 v3.1.8< /a> 将本地数据库迁移到云端。
我想知道是否有人可以指出一个列表或给我任何信息，直到这些功能可能包含在 SQL Azure 中。
I am a relative newbie when it comes to SQL Azure!! I was wondering if there was a definitive list somewhere regarding what is and is not supported by SQL Azure in regards to SQL Server 2008? I have had a look through google but I've noticed some of the blog posts are missing things which I have found through my own testing:
For example, quite a lot is summarised in this blog entry http://www.keepitsimpleandfast.com/2009/12/main-differences-between-sql-azure-and.html
- Common Language Runtime (CLR)
- Database file placement
- Database mirroring
- Distributed queries
- Distributed transactions
- Filegroup management
- Global temporary tables
- Spatial data and indexes
- SQL Server configuration options
- SQL Server Service Broker
- System tables
- Trace Flags
which is a repeat of the MSDN page http://msdn.microsoft.com/en-us/library/ff394115.aspx
I've noticed from my own testing that the following seem to have issues when migrating from SQL Server 2008 to the Azure:
- XML Types (the msdn does mention large custom types - I guess it may include this?? even if the data schema is really small?)
- Multi-part views
I've been using SQL Azure Migration Wizard v3.1.8 to migrate local databases into the cloud.
I was wondering if anyone could point to a list or give me any information till when these features are likely to be included in SQL Azure.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
如果您可以找到 SQL Server 杂志二月号，我相信有两篇文章概述了 Azure 支持的与 SQL Server 2008 相关的内容。
If you can get a hold of the February issue of SQL Server Magazine, there are two articles (I believe) that outline what Azure supports in relation to SQL Server 2008.
我昨天参加了 Azure 培训，确认不支持 XML 架构。您还可以在此处找到电子诊所 https://www .microsoftelearning.com/eLearning/courseDetail.aspx?courseId=168190&tab=overview 很有用。
I was at an Azure training yesterday where it was confirmed that XML schemas are not supported. You may also find the e-clinic here https://www.microsoftelearning.com/eLearning/courseDetail.aspx?courseId=168190&tab=overview useful.
该文档比您列出的链接更详细一些。它的日期是 2009 年 9 月，但我相信仍然基本准确。
http://go.microsoft.com/?linkid=9703594
其中一个关键段落文档内容是：
Analysis Services、Replication、Reporting Services 和 Service Broker 目前在 SQL Azure 上不作为服务提供。
This document is a little more detailed than the links you listed. It's dated September 2009 but I believe is still mostly accurate.
http://go.microsoft.com/?linkid=9703594
One key paragraph from this document is:
Analysis Services, Replication, Reporting Services, and Service Broker are not currently provided as services on the SQL Azure.