CODEWITHSUNDEEP
sql-serverazure-devopsssas
Rich Uchytil
Rich Uchytil

Reputation: 509

How to deploy a SQL Server SSAS cube to different environments/servers in DevOps

I have a SSAS multidimensional cube built and have been able to deploy it to our dev environment with Azure DevOps using a PowerShell script that runs the Microsoft.AnalysisServices.Deployment.exe program. I'm not creating a XMLA file because I discovered when I deploy the XMLA file, the role memberships in the cube get overwritten with what's in the project and I don't want that. If I just use the .exe to deploy the cube, the role memberships don't change. (btw, if there's a better way to do it, I'd love to hear about it.)

Now I want to deploy the cube to our test environment which is on a different server, and the data source is a different server. In other DevOps deployments I've done, the projects have a way to use variables for things like the server names. In SSIS it's a project.param file. In MSBuild database project, it's SQLCmd variables which I can set in DevOps and pass to the deployment. I can't find anything like that with a SSAS cube.

How do I deploy the cube with Azure DevOps to different environments with different server names?

Upvotes: 0

Views: 49

Answers (0)

Related Questions