Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in DevOps and Agile by (29.3k points)

How do I deploy an SSAS Cube project from TFS 2015?

For regular database projects, it is sqlpackage.exe /publish with a publish profile.

What is the command line argument to auto-deploy SSAS Project Model into a server?

We are currently using SQL Server 2016 Enterprise.

1 Answer

0 votes
by (50.2k points)

To deploy a ssas project using the tfs command line you need to use 

Microsoft.AnalysisServices.Deployment.exe

Which is located in

C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio

To deploy ssas the syntax for that is :

Microsoft.AnalysisServices.Deployment [ASdatabasefile]  {[/s[:logfile]] | [/a] | [[/o[:output_script_file]] [/d]]}

Note: make sure to use /s which will help to run in silent mode which prevents the opening of a wizard.

Reference: https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/deploy-model-solutions-with-the-deployment-utility?view=sql-server-2016

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94k users

Browse Categories

...