Pulse7
8/14/2017 - 11:11 AM

VSTS team services sqlpackage.exe deploy database script

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"