SQL Server Data Migration Tools and Services

Sergio Govoni
2 min readJun 20, 2020

The Database Migration Team of the SQL Server Product Group has created the following tools and services to facilitate migration between different versions of SQL Server or between on-premises and Azure SQL Database in the cloud, but not only!

Azure Database Migration Service (Azure DMS)

Designed as a seamless, end-to-end solution for moving on-premises SQL Server databases to the cloud: https://aka.ms/AzureDMS

Database Migration Guide

Review all your options for an upgrade from on-premise SQL Server versions to Azure SQL Database: https://datamigration.microsoft.com

Azure Migrate

Easily discover, assess and migrate your on-premises virtual machine to Azure: https://azure.microsoft.com/en-us/services/azure-migrate/

Azure Data Factory (ADF)

Create, schedule and manage your data integration at scale with our hybrid data integration (ETL) service: https://aka.ms/adf

Data Migration Assistant (DMA)

Prepare your upgrade to a modern data platform by reviewing compatibility with your new SQL Server: https://aka.ms/dma

SQL Server Migration Assistant (SSMA)

Automate database migrations to SQL Server from Microsoft Access, DB2, MySQL, Oracle, and SAP ASE: https://aka.ms/get-ssma

Database Experimentation Assistant (DEA)

An A/B testing solution for changes in SQL Server environments, such as upgrades or new indexes: https://aka.ms/dea-tool

SQL Server Data Tools (SSDT)

A modern development tool for SQL Server databases, Azure SQL databases, RS data models and IS packages: https://docs.microsoft.com/en-us/sql/ssdt

Microsoft Data Migration Blog

The official team web log for Azure Data Magnet’s Database Migration Team: https://aka.ms/dm_blog

If you are considering the migration to Azure SQL Database, I suggest you read this white paper: Choosing your database migration path to Azure.

For more information, you can follow the Data Migration Team YouTube channel, you will find videos and tutorials on SQL Server Data Migration Tools.

This opportunity is perfect to remind you that SQL Server 2008 and SQL Server 2008 R2 are out of maintenance, Microsoft will not release updates on these two products, not even security updates. You can find all details here!

You can also provide your feedback on Data Migration Tools and Services by writing to @Data_Migrations (datamigration at microsoft dot com).

Sergio Govoni

CTO at Centro Software, Microsoft Data Platform MVP