的Visual Studio 2013发布数据库天青 [英] Visual Studio 2013 Publish Database to Azure

问题描述

我已经建立在Visual Studio 2013年我已经设置了目标平台为Windows Azure的SQL数据库新的数据库项目。该项目是近空，除1 .sql文件的创建模式。

I have created a new "Database" project in Visual Studio 2013. I have set the Target platform to "Windows Azure SQL Database". The project is nearly empty, with the exception of one .sql file to create a Schema.

当我尝试发布项目，它需要几分钟的时间，结尾：

When I try to publish the project, it takes several minutes and ends with:

创建发布preVIEW ...
未能导入目标模型[数据库名称]。详细信息无法重新连接到数据库：超时过期。操作完成或服务器之前经过的超时时间没有响应。

Creating publish preview... Failed to import target model [database_name]. Detailed message Unable to reconnect to database: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

我已经测试连接字符串，它的作品。

I have tested the connection string, and it works.

我需要做什么做发布到Azure的？谢谢你。

What do I need to do to publish to Azure? Thanks.

推荐答案

像Hesham在评论中提到的，我也有这个问题与Azure的SQL数据库的新基础层。切换层来S0标准尺寸固定的问题。所以，如果你遇到与基本层次问题，请尝试扩展到出版，然后缩减下来的时候，你就完蛋了。

Like Hesham mentioned in the comments, I also had this issue with the new Basic tier of Azure SQL Database. Switching the tier to Standard S0 size fixed the issue. So if you're having issues with the Basic tier, try scaling up to publish, then scale back down when you're finished.

这篇关于的Visual Studio 2013发布数据库天青的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！