How to autmatically copy SSAS cube script from one envinment to another

Mina Kamel 101 Reputation points


I'm looking for help. I'm trying to only copy the metadata of cubes between servers with out copying the data using Powershell.

any help here would be really appreciated .

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,207 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,170 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Nandan Hegde 27,241 Reputation points MVP

    Hey @Mina Kamel ,
    You can use ASPAC to deploy the meta data from 1 server to another using powershell.

  2. Lukas Yu -MSFT 5,806 Reputation points


    Was it SSAS tabular or SSAS multidimensional cube server?
    If it is tabular, you could use the powershell script in this thread and to output the metadata of one database : Microsoft.AnalysisServices.Tabular.JsonScripter output to a file insted of CMD

    Or you could try the snippet in this blog : PowerShell: Backup All SSAS Databases


  3. Mina Kamel 101 Reputation points

    Hello Lukas,

    sorry for the late replay it is a tabular data. However the link you provided only allows me to extract the data and save it locally. if I need to copy the jason file to different server to form only the metadata of the cube what can I do there.

    thanks for all the help in advance.

    0 comments No comments