Report on your consolidated Data Migration Assistant Assessments With PowerBI

In a previous post How to consolidate Assessment Reports we looked at a method to consolidate the JSON output files from the DmaCmd.exe command line tool into SQL Server. Now lets look at a method to put some basic reports on top of that data. For this we will use PowerBi which you can download…


How to Consolidate Data Migration Assistant JSON Assessment Reports

Starting from Data Migration Assistant (DMA) v 2.1, DMA provides command-line support for running assessments in unattended mode.  This feature helps to run the assessments at scale.  The command-line version of DMA generates the assessment results in the form of a JSON or CSV file. You can assess multiple databases in a single instantiation of…

4