comparing 2 tabular models for differences

Question

I have 2 tabular models, I was trying to consolidate them into 1 (I can see most of the dimensions are repeated on both.)

I don't want to miss less visible stuff like calculated columns or roles that the model might have... Is there a way of comparing 2 tabular models and highlight the differences in the models? Or at least some solution where I can export all of it and compare it perhaps with lookups in excel?

Answer 1

The ALM Toolkit should be able to do this for you http://alm-toolkit.com/

Answer 2

Hey @Fra1978 ,
There are multiple ways to compare 2 tabular models:

1) You can use DMV queries to get the cube meta data and compare them in Excel :
https://bennyaustin.com/2011/03/01/ssas-dmv-queries-cube-metadata/

2) Export the TMSL script or code of the tabular models and compare them via text compare :
a crude way in case if both the models are too much different

Hope this is what you were expecting :)

Answer 3

Hi,

There is free opensource tool that you can use in VS to achieve the comparison, check here : BISM Normalizer -Database compare

Regards,
Lukas

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November

Answer 4

You can compare 2 tabular models in Visual Studio with TFS using 'Compare with workspace version' . It provides a complete line by line diff report.