gistfile1.txt

aram([string]$targetConnectionString, [string]$Dacpac, [string]$targetDatabaseName, [string]$Profile)

$dacfxPath = 'C:\Program Files (x86)\Microsoft SQL Server\120\DAC\bin\Microsoft.SqlServer.Dac.dll'

$logs = "C:\DacpacReport"

#create log path
New-Item $logs -ItemType directory -force | out-null;

# Load the DAC assembly
Write-Verbose 'Testing if DACfx was installed...'
$validate = Test-Path $dacfxPath
if (!$dacfxPath) {
    throw 'No usable version of Dac Fx found.'
}
Write-Verbose -Verbose 'DacFX found, attempting to load DAC assembly...'
Add-Type -Path $dacfxPath
Write-Verbose -Verbose 'Loaded DAC assembly.'

# Load DacPackage
$dacPackage = [Microsoft.SqlServer.Dac.DacPackage]::Load($Dacpac)

# Load DacProfile
if ($profile -ne " ") {
    $dacProfile = [Microsoft.SqlServer.Dac.DacProfile]::Load($Profile)
    Write-Host ('Loaded publish profile ''{0}''.' -f $Profile)
}
else {
    $dacProfile = New-Object Microsoft.SqlServer.Dac.DacDeployOptions -Property @{
        'BlockOnPossibleDataLoss' = $true;
        'DropObjectsNotInSource'  = $false;
        'ScriptDatabaseOptions'   = $true;
        'IgnorePermissions'       = $true;
        'IgnoreRoleMembership'    = $true
    }
}

# Setup DacServices
$server = "server=$targetConnectionString"
$dacServices = New-Object Microsoft.SqlServer.Dac.DacServices $server

# Deploy package
try {
    Write-Host 'Starting Dacpac deployment...'
    $dacServices.GenerateDeployScript($dacPackage, $targetDatabaseName, $dacProfile.DeployOptions) | Out-File "$logs\$targetDatabaseName.sql"
    $dacServices.Deploy($dacPackage, $targetDatabaseName, $true, $dacProfile.DeployOptions, $null)
    Write-Host 'Deployment succeeded!'
}
catch [Microsoft.SqlServer.Dac.DacServicesException] {
    throw ('Deployment failed: ''{0}'' Reason: ''{1}''' -f $_.Exception.Message, $_.Exception.InnerException.Message)
}