Automation · Continuous Integration · Deployment · SSAS

Deploy a SQL Server Analysis Services Project using PowerShell

Step 1: Build SQL Server Analysis Services solution using devenv /build, for example “<path>\devenv.com” AdventureWorksSSAS.sln /build Development In the bin folder of your solution, you should find <projName>.asdatabase, <projName>.deploymentoptions, <projName>.deploymenttargets and <projName>.configsettings XML files Step 2: Generate XMLA script using Microsoft.AnalysisServices.Deployment.exe Microsoft.AnalysisServices.Deployment.exe <path>\AdventureWorksSSAS.asdatabase /s:GenerateXmla.log /o:SSASDatabase.xmla Step 3. Execute XMLA on target server using PowerShell script. [System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.AnalysisServices.AdomdClient”) # Read the target server from .deploymenttargets… Continue reading Deploy a SQL Server Analysis Services Project using PowerShell