Advertisement
jamiet

MSBuild wrapper for sqlpackage.exe

Jul 12th, 2012
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
XML 0.77 KB | None | 0 0
  1. <Project  xmlns="http://schemas.microsoft.com/developer/msbuild/2003"
  2.          DefaultTargets="SSDTDeploy">
  3.   <Target Name="SSDTDeploy" Condition="'$(SSDTProj)' != ''">
  4.     <Message Text="**************Publishing Database project: $(SSDTProj)**************" />
  5.     <PropertyGroup>
  6.       <ProjectPath>$(MSBuildProjectDirectory)\..\..\$(SOLUTION)\$(SSDTProj)</ProjectPath>
  7.     </PropertyGroup>
  8.     <!--The following command-line assumes that you have a publish file at ..\<ProjectRoot>\Publish\$(ENVIRONMENT)_$(USERNAME).publish.xml-->
  9.     <Exec Command="&quot;$(PROGRAMFILES)\Microsoft SQL Server\110\DAC\bin\sqlpackage.exe&quot; /a:Publish /sf:$(ProjectPath)\bin\$(CONFIGURATION)\$(SSDTProj).dacpac /pr:$(ProjectPath)\Publish\$(ENVIRONMENT).publish.xml  />
  10.   </Target>
  11. </Project>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement