Migrating SQL Server databases from AWS RDS to Azure SQL Database using the Azure Database Migration Service

Amazon Web Services Relational Database Service is a well-known platform that several organizations use to host various RDBMS offerings, including Microsoft SQL Server. Customers, after an initial foray into the cloud using RDBMS on platform such as AWS RDS, decide to move to a PaaS (Platform as Service) RDBMS offering, such as Microsoft Azure SQL…


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…


Differentiating Microsoft’s Database Migration Tools and Services

Microsoft provides a suite of tools and services designed to assist users with migrating various types of source databases to a variety of target environments. A description of these tools and services is provided in the following sections. Azure Database Migration Service (Azure DMS) Azure DMS is an Azure-based service that is now available in Public…


Release: Data Migration Assistant (DMA) v3.3

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…


Released: Data Migration Assistant (DMA) v3.2

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 allows you to not only move your schema and data, but also uncontained…

7

Benchmark: Data migration to Azure SQL Database using DMA 3.2

DMA 3.2 enables schema and data migration from an on-premises SQL Server database to an Azure SQL Database. The data migration pipeline is built atop the SQL bulk copy technology and lets you quickly and reliably move data from your source database into your target database. There are many variables that can affect the performance…

0

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…


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

Data Migration Assistant: FAQs

This page addresses all the frequently asked questions. 1. What is the difference between the Upgrade Advisor (UA) and the Data Migration Assistant (DMA)? All versions of UA are officially deprecated and have been replaced by DMA for your migration needs. The core differences between the tools are as follows: UA performs only assessments, DMA…

12