When I was at SQL Saturday in Dublin a few weeks ago I sat in on a sponsor session given by red-gate and heard that they were working on their first tool for Analysis Services: SSAS Compare. Today it appeared on their labs site and you can download it to check it out yourself:
http://www.red-gate.com/labs/ssas-compare/index
Here’s what they have to say about it:
Red Gate SSAS Compare is a tool for Microsoft Business Intelligence professionals that generates XMLA scripts for partial or complete SSAS cube deployment.
Easily deliver updates from development through test and production, minimizing the time spent processing and validating changes.
It’s a very early release and therefore a bit buggy; in fact I haven’t been able to get it to work at all on my laptop (I suspect it doesn’t work with SSAS 2012). However I’m still very excited by the possibilities of this tool: quite a few of my customers have several versions of the same database, and need to find out how they differ and deploy the same changes to all of them. Definitely something to keep an eye on.
Hi Chris,
Just tried this tool with SSAS 2012 and you’re right. It hasn’t supported SSAS 2012 yet. I am a bit disappointed but I like the idea. I’ve been trying to do develop the same tool before but haven’t got a chance to finish it 🙂
Cheers,
Uzzie
Hi Uzzie,
I’m the SSAS Compare Product Manager and wanted to let you know we are looking into this problem. I have used SSAS Compare successfully with SSAS 2012 so we are investigating what is different for you.
Nick
Hello,
Is there a version for SSAS 2014 (multidim mode) ? Cause the installation of redagate SSAS Compare seems to be locked with sql server 2014.
Thanks in advance for your help,
Adriano.
I don’t know, sorry. It’s not a properly supported product, so it may well not work with 2014.