We’re pleased to announce that SSAS Compare version 1.0 has been released as a free tool. Version 1.0 includes:

Comparisons of live databases and XMLA or Analysis Services Project files

• MDX syntax diffs and highlighting
• Server comparisons
• Deployment wizard with summaries of scripted actions
• Bug fixes and engine and UI refinements

We’ve tested it on as many cube configurations as we could find (not just good old AdventureWorks!), but we can’t provide support for free tools — so if you’re reliant on SSAS Compare for your cube deployment, use it at your own risk. See the user license agreement in the installer for more details.

SSAS Compare’s come a long way from its humble beginnings as an internal tool first developed for Red Gate’s own BI developers. Today’s SSAS Compare is now much more stable — not to mention much easier to use — and something the team is proud to have released with Red Gate’s name on.

Next: Deployment Manager

We’re working on integrating SSAS Compare cube deployment with our new Deployment Manager tool, so you’ll be able to create cube deployment scripts and automate the deployment process, too.  We’re documenting the process in a white paper we’ll publish online in the next week.

Thank you!

Thanks to all the SSAS Compare users out there. Without your feedback, we could never have produced such a stable product so quickly. We hope you continue to find useful.

See you in Deployment Manager!