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.

1 Answers1

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

Hadi
  • 36,233
  • 13
  • 65
  • 124
  • 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. http://www.blue-granite.com/blog/applying-configurations-tabular-model-ms-build – GregGalloway Mar 31 '19 at 20:56
  • 1
    @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 – Hadi Mar 31 '19 at 21:04
  • 2
    Got it. So he wants to publish a stale .asdatabase file. Makes complete sense. – GregGalloway Mar 31 '19 at 21:05