Released: Data Migration Assistant (DMA) v2.1

Overview The Data Migration Assistant 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 objects…

5

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