Redgate – SSAS Compare

 

Background

Needing to compare Sql Server Analysis Server ( SSAS ) database across environments, goggled for tools that will facilitate my needs.

 

Redgate – SSAS Compare

SSAS Compare from Redgate is the tool that Goggle referenced the most.

 

Download

Downloaded the tool from here ( https://www.red-gate.com/products/experimental-tools/ssas-compare/index )

 

Install

Installation is straight forward…

 

Screen Shots

 

Selecting the tools you want to install

selectTheToolsToInstall_20171295_0419AM

 

End User Licensing Agreement

licenseAgreement_20171295_0420AM

 

Customizing the installation folder

customizingTheInstallationFolder_20171295_0421AM

 

Installing Tools

installing_20171295_0422AM

 

Installation Summary

installationSummary_20171295_0423AM

 

 

Usage

 

Options

The tool offers two pathways towards comparing Sql Server Analysis Server ( SSAS ) databases.

Our options are :-

  1. Directly comparing live/active databases
  2. Comparing scripted database file

 

Comparing Live/active databases

Image

New Comparison

newComparison_20171205_0435AM [brushedup]

 

 

Results
Results – Cubes

comparison_Cubes_20171205_0639AM

Results – Data Sources

comparison_DataSource_20171205_0634AM

Results – Data Source Views

comparison_DataSourceViews_20171205_0643AM

Results – Dimension

comparison_Dimensions_20171205_0631AM [brushedup]

 

Results – Roles

comparison_Roles_20171205_0645AM

 

 

Summary

Redgate’s SSAS Compare is a good, small front print, easily accessible tool.