Explore Courses Blog Tutorials Interview Questions
0 votes
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 


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.


Browse Categories