[SSAS] Support msbuild as a mechanism for deploying SSAS cubes/models - by Jamie Thomson

Status : 

 


65
1
Sign in
to vote
ID 759939 Comments
Status Active Workarounds
Type Suggestion Repros 3
Opened 8/28/2012 1:58:33 AM
Access Restriction Public

Description

The Microsoft development ecosystem uses msbuild as its build/deployment mechanism yet the SQL Server team's support is sadly lacking.
The engine team have gone a long way to supporting msbuild through the provision of .dacpacs & SSDT database projects yet the SSIS/SSAS/SSRS teams are still lagging way behind. The teams that I work on embrace msbuild and Continuous Integration as a way to deploy their projects but getting these BI components work in the same way is very very hard.

Can I also suggest that you adopt the .dacpac/.ispac approach of the DB/SSIS teams respectively by providing a (say) .aspac file as a means for distributing the definition of a SSAS solution.

I have provided similar requests for SSRS & SSIS:
https://connect.microsoft.com/SQLServer/feedback/details/759940/ssis-support-msbuild-as-a-mechanism-for-deploying-ssis-ispac-files
https://connect.microsoft.com/SQLServer/feedback/details/759938/ssrs-support-msbuild-as-a-mechanism-for-deploying-ssrs-reports#details
Sign in to post a comment.
Posted by allmhuran on 11/22/2016 at 7:50 PM
As far as I am aware this gap *stll* exists in TFS 2015, and I haven't been able to determine whether it still exists in 2017. Is it still the case, now 4 years later, that Microsoft tools are unable to build and deploy Microsoft solutions?
Posted by JuliaJulia on 10/5/2015 at 4:49 AM
This is a major gap in our build and deploy automation.
Posted by Microsoft on 12/7/2012 at 8:43 AM
Hi Jamie,

Thank you for your feedback, we will look into this issue for a future release.

Thanks,
Kasper de Jonge
Analysis services team