Azure Data Migration

In this article we can explore the Data Migration Assistant Tool of Microsoft. It helps in Migrating your Local SQL Server database to SQL Azure.

Data Migration Assistant

Data Migration Assistant is a Great Tool from Microsoft providing:

· Assessment checks on Compatibility of Source Database

· Actual Migration of Schema & Data

Download

You can download the tool from:

https://www.microsoft.com/en-us/download/details.aspx?id=53595

Running the Tool

After installation, the tool one execution looks like below:

We can try Migration using the + button from the left.

Enter the Source & Target database types.

Connect to the Source server.

On running the checks, you can see the results below.

Actual Migration

Now let us try performing the actual migration.

Click on the Deploy Schema button now.

Click on the Start data migration button now.

You can see the Migration is complete without any errors.

Summary

In this article we have explored using the Data Migration Tool from Microsoft.

Advertisement