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

问题描述

看起来像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（完整，快速甚至CE） - 只需使用本地连接字符串代替.cscfg或.config文件中的SQL Azure - 然后本地计算实例将像任何其他本地进程一样连接。

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是兼容和可互换的。 Microsoft声称SQL Azure与SQL Server 2008 R2共享其大部分代码库。因此，您可以在本地使用SQL Server 2008 R2或SQL Server 2008 Express，以测试您的应用程序。确实，对于简单应用程序，您还应该能够使用新的基于文件的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有一些限制 - 请参阅 http： //msdn.microsoft.com/en-us/library/ee336245.aspx - 但对于许多ASP.Net应用程序，您应该只能从SQL express迁移到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与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屋！