我如何对SQL Azure的本地测试？ [英] How do I test locally against SQL Azure?

问题描述

看起来像Azure存储模拟器省略了SQL Azure上。是否持有真的吗？那我怎么没有部署它到现场云测试我的应用程序，它使用SQL Azure的？

Looks like Azure Storage Emulator omits SQL Azure. Does it hold true? Then how do I test my application that uses SQL Azure without deploying it onto live cloud?

推荐答案

有关本地测试，您可以在应用程序中使用本地SQL Server（满，EX preSS甚至CE） - 只使用当地的ConnectionString的到位在SQL Azure中的人在你的.cscfg或.config文件的 - 那么本地计算实例将连接就像任何其他地方的过程将

For local testing, you can use a local SQL Server (full, express or even CE) within your app - just use local connectionstring's in place of the SQL Azure ones in your .cscfg or .config files - then the local compute instance will connect just like any other local process would.

有关的大部分本地SQL及SQL Azure是兼容的和可互换的。微软声称，SQL Azure的股票多与SQL Server 2008 R2的codeBase类的。因此，您可以以测试你的应用使用SQL Server 2008 R2或SQL Server 2008前preSS本地。的确，对于简单的应用程序，你也应该能够使用新的基于文件的SQL Server CE。

For the most part local SQL and SQL Azure are compatible and interchangeable. Microsoft claim that SQL Azure shares much of its codebase with SQL Server 2008 R2. As a result you can use SQL Server 2008 R2 or SQL Server 2008 Express locally in order to test your application. Indeed, for "simple" applications you should also be able to use the new file-based SQL Server CE.

有关先进的应用，再就是与SQL Azure的一些限制 - 请看<一个限制href=\"http://msdn.microsoft.com/en-us/library/ee336245.aspx\">http://msdn.microsoft.com/en-us/library/ee336245.aspx - 但对于许多ASP.Net应用程序，你应该能够刚刚从SQL前preSS迁移到SQL Azure的

For "advanced" applications, then there are some limitations with SQL Azure - see limitations on http://msdn.microsoft.com/en-us/library/ee336245.aspx - but for many ASP.Net applications, you should be able to just migrate from SQL express to SQL Azure.

有关SQL的更多详细信息VS SQL Azure的，请参阅http://social.technet.microsoft.com/wiki/contents/articles/comparing-sql-server-with-sql-azure.aspx

For more details on SQL vs SQL Azure, see http://social.technet.microsoft.com/wiki/contents/articles/comparing-sql-server-with-sql-azure.aspx

有关从本地SQL到SQL Azure的迁移数据，请参见codePLEX的SQL迁移向导 - 的http：// sqlazuremw。 codeplex.com /

For migrating data from local SQL to SQL Azure, see the SQL Migration Wizard on Codeplex - http://sqlazuremw.codeplex.com/

这篇关于我如何对SQL Azure的本地测试？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！