Announcing General Availability of the Azure Database Migration Service!

This post has been republished via RSS; it originally appeared at: Microsoft Data Migration articles.

First published on MSDN on May 07, 2018

Authored by rajpo@microsoft.com


The Database Migration Team is pleased to announce General Availability (GA) of the Azure Database Migration Service .

 

Overview

The Azure Database Migration Service (DMS) is a fully managed migration service designed to enable seamless migrations from multiple database sources to Azure Data platforms with minimal downtime. Azure DMS achieves this by integrating functionality from multiple Microsoft migration engines, such as the Data Migration Assistant (DMA), the SQL Server Migration Assistant (SSMA), and the Database Experimentation Assistant (DEA), to cover a wide range of scenarios. Since the November 2017 launch of the service in Public Preview, customers have used Azure DMS and these tools to migrate over 23.7K databases.

Azure DMS leverages this functionality to provide rich orchestration capabilities that enable you to organize your databases into project(s) and perform source assessment, schema and data conversion, and validation activities. In addition, you can assign these activities to one or more compute nodes to ensure that you meet your budget and/or timeframe goals. With these capabilities, Azure DMS makes it easy to plan migration tasks, run proof-of-concept migrations, author scripting for automation, and ensure that your final production migration to the Azure Data Platform is friction-free.

The service is designed as the underpinning of a cloud-scale database migration platform on which we can rapidly enable additional migration scenarios (source-target pairs). Since the beginning of the Azure DMS Private Preview May 2017, we have leveraged customer and partner feedback to identify the features and functionality that they consider most important, and to refine and augment the service accordingly.

Specifically, during Public Preview over the past few months, we have:

    • Added support for SQL Server to Azure SQL Database Managed Instance migrations.
    • Added support for SQL Server running on AWS RDS and GCP to Azure SQL Database migrations
    • Extended availability from 6 to a current total of 23 regions (detailed below in the GA release section).
    • Released CLI interfaces to enhanced cross-platform extensibility.
    • Provided the ability to provision a DMS instance in a specific resource group.
    • Provided action-oriented guidance for source/target server connectivity failures.
    • Added a paging and search experience to the database and table blades to enable scaling for hundreds of databases and tables.
    • Ensured that a current migration activity resumes after a DMS instance comes online after a restart.
    • Enabled customer feedback on every error blade, and the ability for uses to seek further assistance from the feedback forum.


Customer and partners who have used Azure DMS to date have provided very positive reviews of the service. Consider the following examples:

The Azure Database Migration Service was a life saver for us moving our databases to Azure.  We successfully migrated over 100 databases to Azure using the DMS service over a period of two months without any downtime or loss of data. This process would have taken us well over six months and days/weeks of downtime for our users were we to using any other method. We really appreciated working with the DMS team, they made our journey to the cloud practically seamless for our SQL workloads.

Greg Matuskovic, IT Executive and Services Director, Willis Towers Watson

The Azure Database Migration Service helped significantly in many ways. First, it alerted us to changes required. Second, it transferred the data quickly, allowing us to review the progress. Third, and most importantly, it allowed us to transfer data for static tables before transferring the dynamic tables. This was greatly reduced the downtime required to move to the cloud. Being part of the preview of this product was a life saver for me and my team.

Jeff Schwartz, Hosted Services Manager, Innovative Systems

With additional migration scenarios and functionality in Preview, we look forward to continuing to gather valuable input that we can use to make the service even better!

For more information refer to: https://azure.microsoft.com/en-us/services/database-migration

 

GA release

Today’s GA release of Azure DMS includes support for the following one-time migration scenarios:

    • SQL Server to Azure SQL Database
    • SQL Server to Azure SQL Database Managed Instance


At GA, the Azure Database Migration Service is available in the regions shown in the following graphic.

 

Scenarios in Preview

In addition to the features and functionality included with the GA release, we also have migration scenarios in Public and Private Preview.

 

Public preview

In Public preview, Azure DMS now supports migrations from SQL Server to Azure SQL Database Managed Instance (one-time migration).

 

Private preview

We also have several scenarios in Private preview:

One-time migrations

    • Oracle to Azure SQL Database
    • Oracle to Azure SQL Database Managed Instance
    • MySQL to Azure SQL Database
    • SQL Server to SQL Server on Azure Virtual Machines


Minimal-downtime migrations

    • SQL Server to Azure SQL Database
    • SQL Server to Azure SQL Database Managed Instance
    • MySQL to Azure Database for MySQL
    • PostgreSQL to Azure Database for PostgreSQL


Note : If you are interested in participating in one or more of our Azure DMS Private preview, please contact the Azure DMS Feedback alias .

 

Next steps

To find out more about this exciting new service and how it can help with your migration efforts, view the following resources:

    • For detailed documentation on how to use Azure DMS, go here .
    • To begin using Azure DMS for your Microsoft SQL Server to Azure SQL Database migrations, log in to the Azure portal with your Azure account credentials, and then set up an instance .
    • To provide feedback on your experiences using the Azure Database Migration Service, go here .

 

Other resources

For information about additional migration tools and services, view the following resources:

 

In summary

Take advantage of our latest migration offering today and let us know what you think! We look forward to working with you to realize the full potential the Azure Database Migration Service!

Regards,

Raj Pochiraju (rajpo@microsoft.com)
Principal Program Manager,
Microsoft Database Migration Team

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.