Menu
Does anyone know of an SSAS specific tool that compares SSAS databases? Not their data, just schema and maybe partition definitions. When I say tool - something that knows about SSAS and has that business knowledge built into it.
374
To compare database definitions. On the Tools menu, select SQL Server, and then click New Schema Comparison. Alternatively, right-click the TradeDev project in Solution Explorer, and select Schema Compare. The Schema Compare window opens, and Visual Studio automatically assigns it a name such as SqlSchemaCompare1 .
Microsoft SQL Server Analysis Services (SSAS) is an online analytical processing (OLAP) and data mining tool in Microsoft SQL Server. SSAS is used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files.
One of the main difference between Azure AS and SSAS is, where the model is deployed; although the development experience is exactly the same. 13. With Azure AS, the users would be paying for the resources when they actually use them. You can also pause servers when not required and paused servers cost nothing.
I'm a Product Manager at Red Gate. We have just released a free preview of SSAS Compare. This allows you to review, script and deploy changes between SSAS instances.
http://www.red-gate.com/products/bi-tools/ssas-compare/
142
You can use BIDS helper (the free add-on to BIDS): http://bidshelper.codeplex.com/
This has "smart diff" option which allows different files (such as SSIS packages and SSAS XMLA schemas) to be compared. Smart diff provides more meaningful comparisons when comparing XML files.
So first you need to script out your DBs in SSMS by rclick > script database as > create to
then in BIDS use smart diff to compare the XMLA scripts to see the differences.
20
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
