SSAS Compare
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
Uzzie
May 22, 2012 at 12:14 am
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
Nick Sutherland
May 24, 2012 at 1:30 pm