Compare SSAS projects or .ASDATABASE files
Support comparison between deployed Databases and SSAS Projects created in Visual Studio
Latest release supports comparing .asdatabase and .xmla files.
1 comment
-
Shannon Hall
commented
I found that when comparing Project file to Database, there were some difference that didn't exists when comparing database to database as follows:
(prj1 to asq2)Name columns Data type / Length properties for a particular Dimension didn't not get captured on the project file side. This caused a difference to be detected when compared to the database.
This didn't happen for every dimension. I'm not sure what's different (if anything) in this dimension that may cause the properties from being selected on yet. But when comparing that same project deployed to a database (asp2) to that same database(asq1), this comparison was corrected with properties for the given dimension. There may be something a bit different when comparing to the file maybe?
I will follow up if I find more details.
Awesome Tool Though!