Script.PostDeployment.sql not executing in CI build VS 2010_问答_开发者

Script.PostDeployment.sql not executing in CI build VS 2010

开发者 https://www.devze.com 2023-02-01 10:48 出处：网络

I have a database project in VS 2010 (SQL 2008).The local Deploy Solution action works and executes all of the SQL in the Script.PostDeployment.sql file.When I check changes in, the Build Definition f

I have a database project in VS 2010 (SQL 2008). The local Deploy Solution action works and executes all of the SQL in the Script.PostDeployment.sql file. When I check changes in, the Build Definition for the continuous integration server ex开发者_开发技巧ecutes. The database is deployed into the CI environment, but the PostDeployment script doesn't get executed.

I wasn't able to find anything specific to this particular scenario. I also expect I'll need to provide additional information unless this is a trivial problem that I missed somewhere.

Additional Information:

The build is executing vsdbcmd.exe to deploy.
The deployment manifest references the PostDeployment.sql file and it's present in the path with the rest of the files.

Here is a reference to a thread on social.msdn.microsoft.com regarding this problem.

We found that the VSDBCMD was not referencing the deployment manifest. The /manifest flag was added to the VSDBCMD and the PostDeployment.sql file was executed.