VSTS team services sqlpackage.exe deploy database script
connectionString: Server=(local); Database=Benday.Presidents.Database; Integrated Security=true;
-dacpacPath $(build.sourcesdirectory)\Benday.Presidents.Database\bin\$(BuildConfiguration)\Benday.Presidents.Database.dacpac
-connectionString "$(connectionString)"
param(
[Parameter(Mandatory=$true)]
$dacpacPath,
[Parameter(Mandatory=$true)]
$connectionString)
& 'C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\120\sqlpackage.exe' /action:Publish /sourceFile:"$dacpacPath" /targetconnectionstring:"$connectionString"