Databases
StackOverflow2013
Postsdbo
POTFS2010 Team build - how to deploy databases before running unit tests
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POTFS2010 Team build - how to deploy databases before running unit tests
    text
    copied!<p>I followed <a href="http://msdn.microsoft.com/en-us/library/ff805001.aspx" rel="nofollow">How to prepare database for TFS deployment walkthrough</a></p> <p>and my build script successfully deploys the database at the end of the build process. However, I need the database to be deployed before running unit tests. I tried copying the step and pasting it right above "Get Impacted Tests, Index Sources and Publish Symbols". However, the build process returns the following error: </p> <blockquote> <p><em>*</em> The deployment manifest file Database_Core.deploymanifest does not exist Here is the excerpt from my xaml file for the database deploy:</p> </blockquote> <pre><code> &lt;Sequence DisplayName="Deploy Database" sap:VirtualizedContainerService.HintSize="486,330"&gt; &lt;sap:WorkflowViewStateService.ViewState&gt; &lt;scg:Dictionary x:TypeArguments="x:String, x:Object"&gt; &lt;x:Boolean x:Key="IsExpanded"&gt;True&lt;/x:Boolean&gt; &lt;x:Boolean x:Key="IsPinned"&gt;True&lt;/x:Boolean&gt; &lt;/scg:Dictionary&gt; &lt;/sap:WorkflowViewStateService.ViewState&gt; &lt;If Condition="[BuildDetail.CompilationStatus &amp;lt;&amp;gt; BuildPhaseStatus.Failed]" DisplayName="If Build Succeeded" sap:VirtualizedContainerService.HintSize="464,206"&gt; &lt;sap:WorkflowViewStateService.ViewState&gt; &lt;scg:Dictionary x:TypeArguments="x:String, x:Object"&gt; &lt;x:Boolean x:Key="IsPinned"&gt;True&lt;/x:Boolean&gt; &lt;/scg:Dictionary&gt; &lt;/sap:WorkflowViewStateService.ViewState&gt; &lt;If.Then&gt; &lt;mtbwa:InvokeProcess Arguments="[&amp;quot;/a:Deploy /cs:&amp;quot;&amp;quot;Data Source=MyServer-SQL1\BUILD;Integrated Security=True;Pooling=False&amp;quot;&amp;quot; /dd+ /dsp:Sql /manifest:Database_Core.deploymanifest&amp;quot;]" DisplayName="Invoke VSDBCMD" FileName="C:\Program Files (x86)\Microsoft Visual Studio 10.0\VSTSDB\Deploy\VSDBCMD.EXE" sap:VirtualizedContainerService.HintSize="219,100" WorkingDirectory="[BuildDetail.DropLocation]"&gt; &lt;mtbwa:InvokeProcess.ErrorDataReceived&gt; &lt;ActivityAction x:TypeArguments="x:String"&gt; &lt;ActivityAction.Argument&gt; &lt;DelegateInArgument x:TypeArguments="x:String" Name="errOutput" /&gt; &lt;/ActivityAction.Argument&gt; &lt;mtbwa:WriteBuildError DisplayName="VSDBCMD Error" sap:VirtualizedContainerService.HintSize="200,22" Message="[errOutput]" /&gt; &lt;/ActivityAction&gt; &lt;/mtbwa:InvokeProcess.ErrorDataReceived&gt; &lt;mtbwa:InvokeProcess.OutputDataReceived&gt; &lt;ActivityAction x:TypeArguments="x:String"&gt; &lt;ActivityAction.Argument&gt; &lt;DelegateInArgument x:TypeArguments="x:String" Name="stdOutput" /&gt; &lt;/ActivityAction.Argument&gt; &lt;mtbwa:WriteBuildMessage DisplayName="VSDBCMD Output" sap:VirtualizedContainerService.HintSize="200,22" Importance="[Microsoft.TeamFoundation.Build.Client.BuildMessageImportance.High]" Message="[stdOutput]" mva:VisualBasic.Settings="Assembly references and imported namespaces serialized as XML namespaces" /&gt; &lt;/ActivityAction&gt; &lt;/mtbwa:InvokeProcess.OutputDataReceived&gt; &lt;sap:WorkflowViewStateService.ViewState&gt; &lt;scg:Dictionary x:TypeArguments="x:String, x:Object"&gt; &lt;x:Boolean x:Key="IsPinned"&gt;False&lt;/x:Boolean&gt; &lt;/scg:Dictionary&gt; &lt;/sap:WorkflowViewStateService.ViewState&gt; &lt;/mtbwa:InvokeProcess&gt; &lt;/If.Then&gt; &lt;If.Else&gt; &lt;mtbwa:WriteBuildWarning DisplayName="Deployment Skipped" sap:VirtualizedContainerService.HintSize="220,100" Message="Database deployment was skipped" /&gt; &lt;/If.Else&gt; &lt;/If&gt; &lt;/Sequence&gt; </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload