Ways to Migrate SQL Server Database to Azure SQL Database

Summary: In this article, we have discussed the ways to migrate SQL Server database to Azure SQL Database. We have discussed the best possible ways to perform this task by using the manual and as well as expert solutions.

At the point when business associations need to move their data to the cloud platform, their initial motive is that the cloud is just supposed to save files and documents. Yet, it isn’t altogether true. You can keep your database files in cloud-based applications.

Microsoft SQL Server is the best on-premises database the management tool that associations use to spare their business data. At the point when they wish to migrate the SQL server data assets to the cloud, they delay moving the SQL data to the cloud. But, there is Azure Database Migration Service which you can use and move the SQL data to the Azure cloud server.

Note: Try FreeViewer SQL Recovery Software to Recover Deleted database components of SQL Server. This software supports SQL Server 2019, 2017, 2016, 2014, 2012, and its below version.

Migrate SQL Server Database to Azure SQL Database Manually

In this blog, we will experience the step-by-step migration of the on-premises SQL Server database to the online Azure database. There are the following steps which you have to perform consecutively.

  1. Use Data Migration Assistant to assess the on-premises data
  2. Use Data Migration Assistant to migrate a Sample Schema
  3. Make an Azure Database Migration Service
  4. Make another migration venture with Azure Database Migration Service
  5. Start the migration
  6. Check the migration progress
  7. Perform the migration cutover.

1. Use Data Migration Assistant to Assess the On-Premises Data

Before beginning the migration, first, assess the on-premises data of your SQL server. There is a different utility device called Data Migration assistant which does the examination for you and checks for any conceivable error or bottleneck.

Here are its steps –

  1. Run the tool and click on the New (+) choice, and afterward select the Assessment
  2. Give a project name, pick SQL server as a source server and Azure server as the destination server. At that point click the Create button.
  3. In the Select sources alternative, connect your SQL Server.
  4. In the Add sources alternative, include the database which you need to migrate, and afterward click the Start Assessment

The Data Migration Assistant tool will run an evaluation check and give a total report. The report will give data about similarity issues, and other migration-related subtleties.

2. Use Data Migration Assistant to Migrate a Sample Schema

After running the assessment and getting good outcomes, you can go for making a migration venture for a little sample of the database schema. To migrate the database schema, follow the up and coming steps –

  1. Run the Data Migration Assistant instrument, select the New (+) symbol, and pick new Migration choice under the Project type.
  2. Select the SQL Server as the source server and Azure Server as the destination server.
  3. Select the Schema only alternative under the Migration scope.
  4. At last, go to Create option to make a project. Here, connect with your SQL server and select the database.
  5. Select the Azure Server for the destination server and connect it.
  6. Pick the schema objects from your database.
  7. To make the SQL scripts, select Generate SQL scripts
  8. Finally, convey the schema to the Azure SQL database.

3. Make Azure Database Migration Service

You have to make a case of the Azure Database Migration Service to make a migration venture. Here are the necessary steps –

  1. Initially, you have to enroll a Microsoft.Data migration resource provider by taking its membership.
  2. After registering the resource provider, you can go to the Azure and make a resource under the Azure Database Migration Service.
  3. Indicate a significant name to the migration service, its membership, and the resource group.
  4. Select the location where you need to make the migration.
  5. Either make or select a current virtual system.
  6. Select the pricing level and make the migration service.

4. Make another migration venture with Azure Database Migration Service

At the point when you have effectively made another migration service, you can make a migration venture at the Azure Portal.

  1. Select Azure Database Migration Services under the services, at that point select the migration service which you had made in the past step.
  2. Select the + New Migration Project
  3. Select the SQL server as the source server and Azure SQL Server as the destination server.
  4. For the sort of migration, select Online Data Migration.
  5. Create and run an activity choice permits the creation and run the migration.
  6. Determine the source and target database subtleties, and audit the summary.

4. Start the migration

At the point when you click the Run migration, and the migration action begins.

5. Check the migration

There is a different migration screen where you can tap the Refresh and see the Status of the migration. You can tap on a particular database to get the status of Incremental data sync and Full data load tasks.

6. Perform the migration cutover


After the culmination of the Initial Full load, you can perform migration cutover.

  1. Select Start Cutover and stop all the approaching transactions to the database.
  2. Select Confirm; select Apply.

Expert Solution to Migrate SQL Server Database to Azure SQL Database

SysTools SQL to Azure Database Migrator Tool is a simple SQL Migration tool to migrate offline MDF and NDF files data  from your SQL Server to the Microsoft Azure cloud server. With the help of this application, the user can easily Migrate the deleted database objects to Azure SQL Server. This application is compatible with SQL Server 2019 and below version. To know more the user can download the trial version of the software.

How about we see the simple steps to finish the migration

To move/move information from SQL worker to Azure Database follow these straightforward steps:

  1. Download and Run SysTools SQL to Azure Migration Tool
  2. Click the Open to Browse MDF file
  3. Preview SQL Server database objects for example Table, Views, and so forth
  4. Click Migrate to start the migration
  5. Enter Server Name, Login accreditations and click on the “Connect”
  6. Select relocate ‘With Only Schema’ or ‘With Schema and Data’
  7. Finally, click the Migrate button

Last words

In this article, we have talked about how to Migrate SQL Server Database to Azure SQL Database. Both the manual and the automated strategies are appropriate for the SQL database to Azure SQL migration. In any case, while using the SysTools Migrator of SQL Server, you can perform the migration in less time.


About Jackson Andrew

I am SQL Server database administrator having 9+ years of Experience in SQL Database management. I love to share my knowledge of SQL server related problems.

Leave a Reply

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