Assess an Enterprise With Data Migration Assistant–Part 4: Report on an Assessment

In my previous post I took you through how to consume the assessment data into the DMAWarehouse. In this post I’ll take you through the PowerBI report to visualize your upgrade / migration readiness.   DMA Reports If you haven’t already downloaded the PowerBI desktop then download it here. Open the DMA Reports PowerBI template…

0

Assess an Enterprise With Data Migration Assistant–Part 3: Loading an Assessment

In my previous post I took you through how to run a scaled assessment using the dmaDataCollector PowerShell function. In this post I’ll take you through how to consume the assessment JSON output using the dmaProcessor PowerShell function.   Consuming the assessment JSON file Once your assessment has finished you are now ready to import…

0

Assess an Enterprise With Data Migration Assistant–Part 2: Running an Assessment

In my previous post I took you through the prerequisites for successfully running a scaled assessment against your SQL Server enterprise. In this post I’ll take you through how to run a scaled assessment using the dmaDataCollector PowerShell script.   Running a scaled assessment Ensure that the PowerShell modules have been loaded into the modules…

0

Assess an Enterprise With Data Migration Assistant–Part 1: Prerequisites

In my previous posts How to Consolidate JSON Assessment Reports and Report on Your Consolidadted Assessments With PowerBI, I show how to run scaled DMA assessments across your estate and report on the results using PowerBI. In the next series of posts I’ll take you through the enhancements to the process, scripts and reports to…

0

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…

0

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