How to consolidate 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…

6

Released: Data Migration Assistant (DMA) v3.0

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…


Server Logins migration using Data Migration Assistant (DMA)

In this blog, I will try to demystify the SQL server logins migration using Data Migration Assistant (DMA) DMA assists you to migrate the logins based on a Windows principal (such as a domain user or a Windows domain group) and logins created based on SQL authentication, also called as SQL Server logins. DMA currently doesn’t…

0

Released: Data Migration Assistant (DMA) v2.0

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…


Data Migration Assistant: How to migrate your on-premises SQL Server instance to modern SQL Server platforms

Data Migration Assistant (DMA) provides seamless assessments and migrations to modern on-premises SQL Server and SQL Azure VM data platforms.  The following step-by-step instructions will help you to perform your first SQL server migration using DMA. Create new migration project Click on the “New(+)” button on left pane and select “Migration” project type. Set the source and…

0

Released: Data Migration Assistant (DMA) v1.0

Overview The Data Migration Assistant (DMA) delivers scenarios that reduce the effort to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality after an upgrade. It recommends performance and reliability improvements for your target environment. DMA replaces the SQL Server Upgrade Advisor. What’s new in v1.0? Discovery of issues…


Data Migration Assistant: How to assess your on-premises SQL Server instance

The following step-by-step instructions will help you to perform your first assessment migrating to either on-premises SQL Server or SQL Server running on Azure VM or Azure SQL Server database using DMA. Create new assessment Click on the New(+) icon and select “Assessment” project type. Set the source and target server type to SQL Server…

17

Data Migration Assistant: Best Practices

Follow these best practices to run Data Migration Assistant: General: Do not install and execute Data Migration Assistance (DMA) directly on SQL Server host machine. Assessment: Run assessments on production databases during non-peak times. Perform the “Compatibility issues” and “New feature recommendations” assessments separately to reduce the assessment duration. Migration: Migrate a server during non-peak times. When migrating a…

4

Data Migration Assistant: Known Issues (v1.0)

Execution Timeout Expired While running assessment you might encounter an execution timeout with an error message similar to the one below: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The request failed to run because the batch is aborted, this can be caused by…

24