Skip to content

Instantly share code, notes, and snippets.

@RichieBzzzt
Created September 22, 2017 10:42
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save RichieBzzzt/16f2fd1b97be655d5b88b722749cfb63 to your computer and use it in GitHub Desktop.
function publish-SsasDb {
[CmdletBinding()]
param(
[Parameter(Position = 0, mandatory = $true)]
[string] $TargetSsasSvr,
[Parameter(Position = 1, mandatory = $true)]
[string] $sourceDb,
[Parameter()]
[switch] $runscript,
[Parameter()]
[switch] $createScript,
[Parameter()]
[switch] $deployScript)
$script:ASDeployWizard = "C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Microsoft.AnalysisServices.Deployment.exe"
if (!(Test-Path $sourceDb)) {
Write-Error -message "The path to [$sourceDb] is either not accessable or does not exist" -category InvalidArgument
return
}
Write-Host "$(Get-Date): Starting"
Trap {Write-Host "Failed to publish database ($_.Exception.Message)" -foregroundcolor Black -backgroundcolor Red; break}
$path = [System.IO.Path]::GetDirectoryName($sourceDb)
$targetDatabase = [System.IO.Path]::GetFileNameWithoutExtension($sourceDb)
$outputScript = [System.IO.Path]::ChangeExtension($sourceDb, "xmla")
$deploymenttargets = [System.IO.Path]::ChangeExtension($sourceDb, "deploymenttargets")
$logPath = [System.IO.Path]::ChangeExtension($sourceDb, "log")
if ($runscript -or $createScript) {
$arguments = @("`"$sourceDb`"", "/s:`"$logPath`"", "/o:`"$outputScript`"")
}
if ($deployScript) {
$arguments = @("`"$sourceDb`"", "/s:`"$logPath`"")
$arguments
}
Write-Verbose "$(Get-Date): Start deployment wizard from deployment script located at [$sourceDb]. See log file [$logPath] for more info."
Start-Process -FilePath $script:ASDeployWizard -ArgumentList $arguments -Wait
Write-Verbose "$(Get-Date): End deployment wizard from deployment script located at [$sourceDb]. See log file [$logPath] for more info."
if ($runscript -or $createScript) {
if (!(Test-Path $outputScript)) {
Write-Error -message "Path [$outputScript] does not exist. Deployment script has not been generated as expected." -category InvalidOperation
return
}
}
$xmla = [string]::join([Environment]::NewLine, (Get-Content $outputScript))
if ($runscript) {
$xmla = [string]::join([Environment]::NewLine, (Get-Content $outputScript))
Write-Verbose "$(Get-Date): Start Database deployment script [$outputScript]"
$xmlaresult = Execute-Xmla $TargetSsasSvr $xmla
Write-Verbose "Xmla Result: $xmlaresult"
Write-Verbose "$(Get-Date): Finished Database deployment script [$outputScript]"
}
Write-Host "$(Get-Date): Finished"
}
function Execute-Xmla {
[CmdletBinding()]
param(
[Parameter(Position = 0, mandatory = $true)]
[string] $TargetSsasSvr,
[Parameter(Position = 1, mandatory = $true)]
[string] $xmla
)
begin {
Add-Type -AssemblyName "Microsoft.AnalysisServices.AdomdClient, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"
$connectionectionString = "Data Source=$TargetSsasSvr;Provider=MSOLAP.4;Integrated Security=SSPI;Impersonation Level=Impersonate;"
$connection = New-Object Microsoft.AnalysisServices.AdomdClient.AdomdConnection($connectionectionString)
}
process {
$connection.Open()
$comand = $connection.CreateCommand()
$comand.CommandTimeout = 20000
$comand.CommandType = [System.Data.CommandType]::Text
$comand.CommandText = $xmla
$reader = $comand.ExecuteXmlReader()
if ($reader.Read()) {
$return = $reader.ReadOuterXml()
}
return $return
}
end {
$connection.Close();
$connection.Dispose();
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment