Well if you are reading my article then I’m pretty sure that you are using slow, difficult, and very typical Local SQL to Azure SQL Data Migration Techniques that may take hours to migrate local database to cloud.

Now let me share a good news with you that there’s a very simple, very easy and efficient method to migrate local databases even with large amount of data to Microsoft Azure SQL database. Download Microsoft Data Migration Agent and make your life easier.

Data Migration Assistant (DMA) enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality on your new version of SQL Server. It recommends performance and reliability improvements for your target environment. It allows you to not only move your schema and data, but also uncontained objects from your source server to your target server.

If you’re done with the installation then lets see how we can migrate the data with some very easy steps:

Step 1 of Migrating Local SQL to Azure SQL

As shown in the picture above, when you’ll start azure data migration assistant you will have to click + sign to create a new project.  Then you have to provide very simple details that are mentioned on the form.

Use SQL Server as Source Server Type, Target Server Type must be Azure SQL Database and Migration scope depends on you. If you want to migrate empty database then select schema only, if you already have database and just want to migrate data then use data only else if you want to migrate complete local database including schema as well as data then select schema and data option and Finally click the create button to proceed to next step.

Step 2 of Migrating Local SQL to Azure SQL

Well Done, You have created the project successfully, now in the very next window as shown above you have to select local server (database) by providing the instance name of your Local SQL Server with your authentication type, these settings are exactly the same that you use while connecting with your local SQL Server Management Studio.

Click Connect and you will see a list of all your local databases on your right hand side with radio buttons to select any of them. Once you select the desired database click Next to proceed.

Step 3 of Migrating Local SQL to Azure SQL

Excellent, you are so near. Now log on to your azure portal to set security clearance for connecting with Azure SQL Database by setting firewalls. For setting them open your SQL Server in Azure Portal and choose firewall options and click + Add client IP.

Step 4 of Migrating Local SQL to Azure SQL

Perfect, Now you will be able to connect your cloud server from local machine.  Now by providing correct credentials i.e. Username and Password of your Azure SQL Server you can easily connect. Once your connection is successfully established you will be able to see the list of databases present on that server on your right side of data migration agent. Select desired database and click next to proceed.

Final Step of Migrating Local SQL to Azure SQL

Wonderful, You have everything now to begin the process, just follow the wizard and click next button to finish the guide as from this step onwards next screens will be depending on what migration type you selected in the beginning so the easiest way is to just keep clicking next and you are all done.

I hope you like the article don’t forget to share.