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

Mina Kamel 101 Reputation points
2021-02-11T15:18:15.043+00:00

Hello,

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,245 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,381 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 29,891 Reputation points MVP
    2021-02-12T05:53:51.02+00:00

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

  2. Lukas Yu -MSFT 5,816 Reputation points
    2021-02-12T06:47:30.257+00:00

    Hi,

    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

    Regards,
    Lukas

  3. Mina Kamel 101 Reputation points
    2021-02-22T14:22:36.057+00:00

    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