Entity Framework VSTS.ps1

#
# Build Task - Pack the Migration 
#

$dataDir = "$(System.DefaultWorkingDirectory)\Acme.Data\bin\Release"
$migrationExePath = "$(System.DefaultWorkingDirectory)\packages\EntityFramework.6.2.0\tools\migrate.exe"
$stagingDirectory = "$(Build.ArtifactStagingDirectory)\Data"

Write-Output "MigrationPath: $migrationExePath"
Write-Output "DataDir: $dataDir"
Write-Output "Staging Dir: $stagingDirectory"

mkdir $stagingDirectory -Force

write-host "Copying dataDir to stagingDirectory"
copy "$dataDir\*" "$stagingDirectory\" -Recurse

write-host "Copying migrationExePath to stagingDirectory"
copy $migrationExePath "$stagingDirectory\"


#
# Release Task - Run the Migration 
#

Write-Host "Executing directory:"
pwd
write-host "Running migrate.exe against $(SqlServerInstance)..."
.\migrate.exe Acme.Data.dll /connectionString="Data Source=$(SqlServerInstance);Initial Catalog=AcmeDb;Integrated Security=SSPI" /connectionProviderName="System.Data.SqlClient"

## See Advanced for Working Directory