在本地模拟/模拟SQL Azure? [英] Emulate/Simulate SQL Azure Locally?

问题描述

从常规的MS开发人员那里稍稍花时间.

Slightly OT from regular MS development stuff.

我想使用MSSQL 2008作为数据库编写下一个.NET 4.0应用程序，但是以天蓝色就绪"的方式配置存储和访问方法，因此，当新的会计年度在夏天开始时可以想象，我们可以做一些低影响的事情，例如仅更改连接字符串(我知道它不止于此)，并且我们可以只使用SQL Azure.

I would like to write my next .NET 4.0 app using MSSQL 2008 as the DB, but configure the store and access methodologies in such a way as to be "Azure ready", so when the new fiscal year starts in the summer we can conceivably do something low impact like just change a connection string (I know there would be more to it than that) and we can just use SQL Azure.

我确实在 http://www.microsoft.com/上看到了这些东西zh-cn/sqlazure/videos.aspx

有专家咨询过如何做到这一点的建议/指针吗?

Have any gurus seen advice/pointers on how to do that?

谢谢.

推荐答案

Azure在SDK中已经有本地模拟器，您可以使用它们.

Azure has local simulators already in the SDK, you can just use those.

关于从SQL 2k8切换到Azure SQL，请记住，您将失去很多功能. Azure不允许用户定义类型，不能进行全文搜索，并且还会删除很多系统功能.

As for switching from SQL 2k8 to Azure SQL, keep in mind that you will lose a LOT of functionality. Azure allows no user defined types, no full text searches, and also drops a lot of system functions.

Azure SQL每个数据库的最大限制为10 GB，没有例外.而且您无法进行跨数据库查询.

Azure SQL is limited to 10 GB per database, no exceptions. And you cannot do cross database queries.

Azure不支持的SQL Server功能: http://msdn.microsoft. com/en-us/library/ff394115.aspx

SQL Server Features not Supported in Azure: http://msdn.microsoft.com/en-us/library/ff394115.aspx

Azure不支持的T-SQL功能: http://msdn.microsoft .com/en-us/library/ee336250.aspx

T-SQL Features not supported in Azure: http://msdn.microsoft.com/en-us/library/ee336250.aspx

这篇关于在本地模拟/模拟SQL Azure?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！