Azure Database Migration Service Tutorial

Introduction

Azure Database Migration Service (DMS) is a fully managed service designed to enable seamless migrations from multiple database sources to Azure data platforms with minimal downtime. This tutorial will guide you through the process of using Azure DMS from start to finish.

Prerequisites

Before you begin, ensure you have the following:

• An active Azure subscription.
• Source and target database connection information.
• Azure SQL Database or Azure SQL Managed Instance as the target database.

Step 1: Create an Azure Database Migration Service Instance

To create an instance of Azure DMS, follow these steps:

1. Log in to the Azure portal.
2. Click on "Create a resource" and search for "Azure Database Migration Service".
3. Select "Azure Database Migration Service" and click "Create".
4. Fill in the required information:
   • Service name: A unique name for your migration service.
   • Subscription: Select your Azure subscription.
   • Resource group: Create a new resource group or select an existing one.
   • Location: Choose a location close to your source or target database.
   • Pricing tier: Select the appropriate pricing tier based on your needs.
5. Click "Review + create" and then "Create".

Step 2: Create a Migration Project

After creating an Azure DMS instance, you need to create a migration project:

1. Navigate to your Azure DMS instance.
2. Click on "New Migration Project".
3. Fill in the required information:
   • Project name: A name for your migration project.
   • Source server type: Select the type of your source database (e.g., SQL Server).
   • Target server type: Select the type of your target database (e.g., Azure SQL Database).
   • Choose type of activity: Select "Online data migration" or "Offline data migration" based on your preference.
4. Click "Save".

Step 3: Configure Source and Target

Next, configure the source and target connections:

1. In your migration project, click "Add Source".
2. Fill in the source connection details:
   • Server name: The name of your source server.
   • Authentication type: Select the authentication type.
   • Username and Password: Provide the necessary credentials.
3. Click "Save".
4. Click "Add Target".
5. Fill in the target connection details:
   • Server name: The name of your target server.
   • Authentication type: Select the authentication type.
   • Username and Password: Provide the necessary credentials.
6. Click "Save".

Step 4: Select Databases for Migration

Select the databases you want to migrate:

1. In your migration project, click "Select databases".
2. Select the databases you want to migrate from the source server.
3. Click "Save".

Step 5: Run the Migration

Finally, run the migration:

1. In your migration project, click "Run migration".
2. Monitor the migration progress and wait for it to complete.
3. Once the migration is complete, verify the data in the target database.

                        Migration started...
                        Source: SQL Server 2017
                        Target: Azure SQL Database
                        Database: SampleDB
                        Status: In Progress
                    

Conclusion

Congratulations! You have successfully migrated your database using Azure Database Migration Service. This tutorial covered the entire process from creating a DMS instance to configuring source and target, selecting databases, and running the migration.