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:

image

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

Enter the Source & Target database types.

image

image

Connect to the Source server.

image 

image

image

 

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

image

Actual Migration

Now let us try performing the actual migration.

image

image

image

Click on the Deploy Schema button now.

image

Click on the Start data migration button now.

image

image

You can see the Migration are complete without any errors.

Summary

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

Leave a Reply

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