Learning and Sharing
  • Home
  • Blog
  • Linux
  • macOS
  • Virtualization
    • VMware
    • VirtualBox
  • Windows
    • Windows 11
    • Windows 10
    • Windows Server
  • Series
    • Symantec
    • Intune
    • Microsoft Azure
    • Powershell
    • VirtualBox
    • VMware
    • PowerShell Learning
    • Microsoft Graph
  • More
    • Auto Installation
    • AEC Installation
  • Contact
No Result
View All Result
  • Home
  • Blog
  • Linux
  • macOS
  • Virtualization
    • VMware
    • VirtualBox
  • Windows
    • Windows 11
    • Windows 10
    • Windows Server
  • Series
    • Symantec
    • Intune
    • Microsoft Azure
    • Powershell
    • VirtualBox
    • VMware
    • PowerShell Learning
    • Microsoft Graph
  • More
    • Auto Installation
    • AEC Installation
  • Contact
No Result
View All Result
No Result
View All Result

How to Migrate Local SQL Database to Azure SQL Database

June 20, 2022
in Blog, Microsoft Azure, SQL Server
0
ADVERTISEMENT

Table of Contents

Prerequisites

To complete this tutorial, you need to:

  • Have SQL Server 2016 or later.
  • Enable the TCP/IP protocol, which is disabled by default during SQL Server Express installation, by following the instructions in the article How to Enable Remote Connections to SQL Server using IP address.
  • Create a database in Azure SQL Database, which you do by following the details in the article How to Create an Azure SQL Database Single Database in Microsoft Azure.
Bg691

Install DMA Data Migration Assistant

1. Download and install the latest version of the Data Migration Assistant. Open DMA then create a new Assessment project.

  • Assessment type: Database Engine
  • Source server type: SQL Server
  • Target server type: Azure SQL Database
Bg692

2. We’ve install DMA on SQL Server, so in this step, server name is localhost. If you install DMA on a client, let enter your SQL server name to connect to a server.

Bg693

3. Select the database you want to migrate to Azure SQL database.

Bg694
4.When the assessment is complete, the results display as shown in the following graphic:

For databases in Azure SQL Database, the assessments identify feature parity issues and migration blocking issues for deploying to a single database or pooled database.

  • The SQL Server feature parity category provides a comprehensive set of recommendations, alternative approaches available in Azure, and mitigating steps to help you plan the effort into your migration projects.
  • The Compatibility issues category identifies partially supported or unsupported features that reflect compatibility issues that might block migrating SQL Server database(s) to Azure SQL Database. Recommendations are also provided to help you address those issues.
Bg695

Migrate Schema using DMA

After you’re comfortable with the assessment and satisfied that the selected database is a viable candidate for migration to a single database or pooled database in Azure SQL Database, use DMA to migrate the schema to Azure SQL Database.

5. Create a new Migration project in DMA:

  • Project type: Migration
  • Migration scope: Schema only.
Bg696

6. In the Data Migration Assistant, specify the source connection details for your SQL Server, then select the database.

Bg697

6. Specify the target connection details for your Azure SQL Server, then select the target database that you want to migrate to.

Bg698

7. Generate SQL script to create the SQL scripts, then deploy the schema to Azure SQL Database.

Bg699

8. It could take several minutes to complete, let keep it running then move to the next step.

Bg700

Create Azure Database Migration Service

9. Navigate to Azure portal then create a Azure Database Migration Service in the same resource group that you’ve created a Azure SQL Database.

Bg701
Bg702

10. Enter Virtual network name for Azure Database Migration Service.

Bg703

11. Once done, click Go to resource button to navigate to Azure Database Migration Service homepage.

Bg704

Create a New Migration Project

12. Now, create a new migration project for SQL migration.

Bg705

13. Enter desire project name, in the Source server type text box, select SQL Server, in the Target server type text box, select Azure SQL Database, and then for Choose Migration activity type, select Data migration.

Bg706

Specify source database

14. On the Select source screen, specify the connection details for the source SQL Server instance.

Make sure to use a Fully Qualified Domain Name (FQDN) for the source SQL Server instance name. You can also use the IP Address for situations in which DNS name resolution isn’t possible.

This is an Alert If you have not installed a trusted certificate on your source server, select the Trust server certificate check box
Bg707

15. Select databases that you want to migrate to Azure SQL Database and review the expected downtime.

Bg708

Specify target details

16. On the Select target screen, provide authentication settings to your Azure SQL Database.

Bg709

17. In the Map to target databases screen, map the source and the target database for migration.

This is an Alert If the target database contains the same database name as the source database, Azure Database Migration Service selects the target database by default.
Bg710

18. Configuration migration settings, expand the table listing, and then review the list of affected fields.

Azure Database Migration Service auto selects all the empty source tables that exist on the target Azure SQL Database instance. If you want to remigrate tables that already include data, you need to explicitly select the tables on this blade.

Bg711

19. Summary, review the migration configuration and in the Activity name text box, specify a name for the migration activity. Select Start migration.

Bg712

Monitor the migration

20. On the migration activity screen, select Refresh to update the display until the Status of the migration shows as Completed.

Bg713

Finally, you can change the configuration of your app. webapp.. to use the SQL database in Azure to verify it works.

Bg714
5/5 - (2 votes)
Previous Post

How to Create an Azure SQL Database Single Database in Microsoft Azure

Next Post

How to Set Static Private IP Address for Azure Virtual Machine

Related Posts

Running Hyper-V and VMware Workstation on The Same Machine

August 15, 2024

How to Uninstall All Autodesk Products At Once Silently

July 29, 2024
Ftr5

How to Uninstall the Autodesk Genuine Service on Windows

July 29, 2024
Ftr19

How to Fix Windows Cannot Read the ProductKey From the Unattend Answer File in VirtualBox

July 26, 2024
Ftr25

How to Update Windows Terminal in Windows 10/11

July 26, 2024

How to Disable The Beep Sound in WSL Terminal on Windows

July 26, 2024

Leave a Reply Cancel reply

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

Recent Posts

  • How To Turn On uBlock Origin Extension in Chrome (2025)
  • Images Hidden Due To Mature Content Settings In CivitAI
  • Azure OpenAI vs Azure AI Hub, How to Choose the Right One for Your Needs

Categories

Stay in Touch

Discord Server

Join the Discord server with the site members for all questions and discussions.

Telegram Community

Jump in Telegram server. Ask questions and discuss everything with the site members.

Youtube Channel

Watch more videos, learning and sharing with Leo ❤❤❤. Sharing to be better.

Newsletter

Join the movement and receive our weekly Tech related newsletter. It’s Free.

General

Microsoft Windows

Microsoft Office

VMware

VirtualBox

Technology

PowerShell

Microsoft 365

Microsoft Teams

Email Servers

Copyright 2025 © All rights Reserved. Design by Leo with ❤

No Result
View All Result
  • Home
  • Linux
  • Intune
  • macOS
  • VMware
  • VirtualBox
  • Powershell
  • Windows 10
  • Windows 11
  • Microsoft 365
  • Microsoft Azure
  • Microsoft Office
  • Active Directory

No Result
View All Result
  • Home
  • Linux
  • Intune
  • macOS
  • VMware
  • VirtualBox
  • Powershell
  • Windows 10
  • Windows 11
  • Microsoft 365
  • Microsoft Azure
  • Microsoft Office
  • Active Directory