Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

SSAS Compare

with 2 comments

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.

Written by Chris Webb

May 21, 2012 at 9:51 pm

Posted in Analysis Services

2 Responses

Subscribe to comments with RSS.

  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 :)



    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 Sutherland

      May 24, 2012 at 1:30 pm

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Get every new post delivered to your Inbox.

Join 3,962 other followers

%d bloggers like this: