与使用VSTS的SQL部署相关的问题。 [英] Issues related to SQL Deploy using VSTS.

问题描述

我正在尝试使用VSTS的CI CD功能。我正在使用SQL数据库构建一个ASP .Net网站，并尝试将其部署在我的远程计算机上。我有一台安装了SQL Server的Azure计算机。 Web部署顺利，但是当使用Sql查询文件进行SQL Deploy
时，该过程失败并显示错误消息"## error找不到使用搜索模式DBTest部署的文件" （DBTest是我在本地azure机器上创建的数据库。）

我尝试使用.dacpac文件执行部署我得到了类似的错误，没有现有的dacpac文件。

我按照以下链接执行CI CD：

感谢您在此发帖。

请将任务中的 Sql File 选项更改为特定路径，而不仅仅是文件名。  ;您可以使用本地路径或UNC路径。所以Sql文件应该看起来像"C：\ .... \ TFSTest.sql"。或" \\xxxx\ ... \ TFStest.sql " 。

祝你好运，

Hi ,

I'm trying to use the CI CD feature of VSTS. I'm building an ASP .Net website with SQL database and trying to deploy it on my remote machine .I have an Azure Machine installed with SQL Server. The Web deployment goes fine but when it comes to SQL Deploy using Sql query file the process fails with error message "## error no files were found to deploy with search pattern DBTest" (DBTest is data base which I created on my local azure machine.)

I tried to perform the deploy with .dacpac file i get the similar error with no existing dacpac file.

I m following the below link to perform the CI CD:

https://www.visualstudio.com/en-us/docs/build/apps/cd/deploy-webdeploy-iis-deploygroups

Any suggestions how to successfully deploy SQL Database. 

If any other processes are there to perform the CI CD  do let me know.

Attaching the screen shot of my configuration.

Thanks in Advance!

解决方案

Hi Siddhartha Mittal,

Thank you for posting here.

Please change the Sql File option in the task to a specific path not just a file name. You could use a local path or a UNC path. So the Sql File should look like "C:\....\TFSTest.sql" or "\\xxxx\...\TFStest.sql".

Best regards,

这篇关于与使用VSTS的SQL部署相关的问题。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！