Analysis Services

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:

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.

4 thoughts on “SSAS Compare

  1. 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 🙂


    1. 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.

  2. 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,

    1. Chris Webb – My name is Chris Webb, and I work on the Fabric CAT team at Microsoft. I blog about Power BI, Power Query, SQL Server Analysis Services, Azure Analysis Services and Excel.
      Chris Webb says:

      I don’t know, sorry. It’s not a properly supported product, so it may well not work with 2014.

Leave a ReplyCancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.