Release: Data Migration Assistant (DMA) v3.6

Overview The Data Migration Assistant (DMA) enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality on your new version of SQL Server. The tool recommends performance and reliability improvements for your target environment. DMA allows you to move your schema, data, and uncontained objects from your…


Release: Data Migration Assistant (DMA) v3.5

Overview The Data Migration Assistant (DMA) enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality on your new version of SQL Server. The tool recommends performance and reliability improvements for your target environment. DMA allows you to move your schema, data, and uncontained objects from your…

0

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…

2

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…

2

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

Release: Data Migration Assistant (DMA) v3.4

Overview The Data Migration Assistant (DMA) enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality on your new version of SQL Server. The tool recommends performance and reliability improvements for your target environment. DMA allows you to move your schema, data, and uncontained objects from your…


Migrating a SQL Server Database from AWS EC2 to Azure SQL Database by using the Microsoft Data Migration Assistant (DMA)

Amazon Web Services EC2 is a great Infrastructure as a Service (IaaS) platform, and many organizations use it to host SQL Server instances. Using an IaaS platform provides for easy migration scenarios from on-premises deployments, and for many people it’s a perfect first step into cloud. However, many companies soon realize that they are ready…


Report on your consolidated 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…

3

Released: Data Migration Assistant (DMA) v3.1

Overview The Data Migration Assistant (DMA) enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality on your new version of SQL Server. It recommends performance and reliability improvements for your target environment. It also allows you to not only move your schema, data, but also uncontained…