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 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

You must use Microsoft.AnalysisServices.Deployment.exe located in

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

Syntax

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

Make sure to use /s to run in silent mode to prevent opening the wizard:

For more information about the arguments check the following article:

• Deploy Model Solutions with the Deployment Utility

References

• Running the Analysis Services Deployment Wizard at the Command Prompt
• Deploy Model Solutions with the Deployment Utility