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.
Downloaded the tool from here ( https://www.red-gate.com/products/experimental-tools/ssas-compare/index )
Installation is straight forward…
Selecting the tools you want to install
End User Licensing Agreement
Customizing the installation folder
The tool offers two pathways towards comparing Sql Server Analysis Server ( SSAS ) databases.
Our options are :-
- Directly comparing live/active databases
- Comparing scripted database file
Comparing Live/active databases
Results – Cubes
Results – Data Sources
Results – Data Source Views
Results – Dimension
Results – Roles
Redgate’s SSAS Compare is a good, small front print, easily accessible tool.