3

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.

Improve this question

1 Answer 1

Reset to default
2

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:

References

Improve this answer
Sign up to request clarification or add additional context in comments.

3 Comments

I think this answer is the second half of the solution. The first half is automating the build of the project to generate the new .asdatabase file. blue-granite.com/blog/…
@GregGalloway thanks for sharing this article. But the OP didn't mentioned that. he is looking to a command line similar to sqlpackage.exe /publish which is used to deploy ssdt database project
Got it. So he wants to publish a stale .asdatabase file. Makes complete sense.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.