部署失败时，vsdbcmd.exe不会返回错误代码... [英] vsdbcmd.exe doesn't return an error code when deployment fails...

问题描述

我遇到了报告成功部署的vsdbcmd.exe部署问题，但仔细检查后，部署失败了。方案是向函数和相应的调用存储过程添加列 - 当您在管理工作室中运行此部署
时，您将获得"无效列名称"。但是vsdbcmd返回正常。

I'm experiencing issues with vsdbcmd.exe deploys where it is reporting a successful deploy, but on closer inspection, the deploy has failed. A scenario is adding a column to a function and a corresponding calling stored procedure - when you run this deploy in management studio you get "Invalid column Name" but vsdbcmd is returning ok.

推荐答案

您好，

您可以看到以下链接：有关VSDBCmd.exe日志记录的更多信息。

You can see the below link for more information on VSDBCmd.exe logging.

http://qa.social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/2e054921-efde-4963-b415-d9847283338b

还有办法记录VSDBCMD.exe命令的错误输出。我们曾经将输出管道传输到某个日志文件以供将来分析。该命令的一个示例是

Also there is way to log the error output of VSDBCMD.exe command. We used to pipe the output to some log file for future analysis. An example of that command is

"％programfiles％\ Mesrosoft Visual Studio 10.0 \vstsdb \deploy\vsdbcmd"

/ a：部署

/manifest:EnterpriseDB.deploymanifest

/p:DeploymentConfigurationFile=Development.sqldeployment

/p:SqlCommandVariablesFile=Development.sqlcmdvars

/ cs：" Data Source = DEV\sql2008; Integrated Security = true" >> "< Specific Path> \ ApplicaitonDeployment.log"

"%programfiles%\Microsoft Visual Studio 10.0\vstsdb\deploy\vsdbcmd"
/a:Deploy
/manifest:EnterpriseDB.deploymanifest
/p:DeploymentConfigurationFile=Development.sqldeployment
/p:SqlCommandVariablesFile=Development.sqlcmdvars
/cs:"Data Source=DEV\sql2008;Integrated Security=true" >> "<Specific Path>\ApplicaitonDeployment.log"

在部署之后，我们用这个日志文件搜索任何失败字。如果有任何失败的话，我们会尝试纠正错误并再次部署，直到部署成功。

Here after deployment we used to search this log file for any failure word. If there are any failure words, we tried to rectify the errors and deploy it again till the deployment succeeded.

谢谢

这篇关于部署失败时，vsdbcmd.exe不会返回错误代码...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！