THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Sergio Govoni

A place where share my experience on SQL Server and related technologies

SQL Server Data Migration: Tools and Services

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 SQL Azure DB 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.

Database Migration Guide

Review all your options for an upgrade from on-premise SQL Server versions to Azure SQL Database.

Azure Migrate

Easily discover, assess and migrate your on-premises virtual machine to Azure.

Azure Data Factory (ADF)

Create, schedule and manage your data integration at scale with our hybrid data integration (ETL) service.

Data Migration Assistant (DMA)

Prepare your upgrade to a modern data platform by reviewing compatibility with your new SQL Server.

SQL Server Migration Assistant (SSMA)

Automate database migrations to SQL Server from Microsoft Access, DB2, MySQL, Oracle, and SAP ASE.

Database Experimentation Assistant (DEA)

An A/B testing solution for changes in SQL Server environments, such as upgrades or new indexes.

SQL Server Data Tools (SSDT)

A modern development tool for SQL Server databases, Azure SQL databases, RS data models and IS packages.

Microsoft Data Migration Blog

The official team web log for Azure Data Magnet’s Database Migration Team 


If you are considering the migration to SQL Azure 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 the next July 9, 2019 SQL Server 2008 and SQL Server 2008 R2 will exit from the maintenance program, Microsoft will not release updates on these two products, not even security updates. You can find all details here. This is the time to migrate!

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

Published Saturday, January 19, 2019 3:07 PM by Sergio Govoni

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



harveycole310245 said:

Thanks for posting this. Our team Will facilitate the migration.

March 22, 2020 10:25 PM

brielleluna said:

We'd like to do this big move in the future too! Thanks a lot!

April 15, 2020 5:46 AM

brielleluna said:

We are all thinking about this great big move since we think this is really essential to do it these days.

April 15, 2020 5:53 AM

Breana said:

Great information, looking forward to more posts here.

June 4, 2020 9:45 AM

Leave a Comment


This Blog


Privacy Statement