Deploy SSAS Project using TFS Command Line

Question

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.

Answer 1

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