Migrating your on-premises workload to the cloud using the Re-host scenario offers numerous advantages, such as increased scalability, flexibility, and cost savings. By following the step-by-step process outlined in this document, you can ensure a smooth and successful migration.

Remember to assess your workload, choose the right cloud provider, set up the cloud environment, establish network connectivity, replicate and migrate your workload, test and validate, and optimize your cloud environment post-migration. With careful planning and execution, your organization can unlock the full potential of the cloud.

Overview:

This post demonstrates how we can rehost a SQL database running on-prem to Azure. We will explore various migration scenarios and deep dive into how to migrate the application database to Azure SQL Managed Service.

There are various options for database re-hosting, we will explore these scenarios first and when to use which scenario.

This post is the continuation of the previous article on re-host scenario where we covered App re-host in detail.

App modernization- re-host scenario – Rajeev Singh | Coder, Blogger, YouTuber (wpcomstaging.com)

Business drivers

The business drivers remain the same as those described in the App Modernization re-host scenario.

Migration goals

In addition to migration goals, there may be additional requirements for database migration, such as

Minimal administration. Database administration tasks are to be minimized after the application is migrated.

Avoid Azure SQL Database. The client can’t use Azure SQL Database for this application and is looking for alternatives.

Solution design

It’s time to design the solution, let’s look at the current architecture and propose a new one.

Current architecture

• Contoso has one main data center, contoso-datacenter, which is located in New York City. It has a fiber-optic connection to the internet from Metro Ethernet Networks that provides 500 megabits per second. The main data center is fully virtualized by VMware products. Contoso has two VMware hosts running ESXi 6.5 that are managed by vCenter Server 6.5.
• Contoso has three branches across the United States. Each branch is connected locally to the internet by using business-class connections, and each branch is connected to the main data center via VPN with IPsec. This configuration allows Contoso’s entire network to always be connected, and it optimizes internet connectivity.
• Contoso uses DNS servers on its internal network.
• Contoso uses Active Directory for identity management.
• Contoso has an on-premises domain controller, contosodc1. The domain controllers at local branches run on physical servers. The domain controllers run on VMware VMs. The VMware environment is managed by vCenter Server 6.5, vcenter.contoso.com, running on a VM.
• SmartHotel360 is tiered across two VMs, WEBVM and SQLVM, that are located on a VMware host running ESXi version 6.5, contosohost1.contoso.com.

Proposed architecture

In this scenario, Contoso migrates its two-tier, on-premises travel application and database as follows:

• Migrate the application database, SmartHotelDB, to a SQL Managed Instance.
• Migrate the front end, WEBVM, to an Azure VM.
• Decommission the on-premises VMs in the Contoso data center after the migration is complete.

Choose the right Database solution:

Below is the scenario to select the right database migration options:

Tools and Migration Steps:

Migration methods

You can use different migration methods to move your data between SQL Server, Azure SQL Database, and Azure SQL Managed Instance.

Some methods are Online and picking up all changes that are made on the source while you’re running the migration, while in Offline methods you need to stop your workload that is modifying data on the source while the migration is in progress.

In our scenario, let’s consider the business drivers.

• Client can’t use Azure SQL as there are few features not supported by Azure SQL (PaaS solution)
• The client doesn’t want to manage the VM and is looking for a solution.

Azure SQL-managed instances are recommended in the above scenario.

Solution review

The next step is to evaluate the proposed design by listing both pros and cons.

Migration process

Once the review is completed, it’s time now to start the migration work for the web and data tier to Azure by completing the below steps.

1. Landing zone for migration:

Add a couple of specific components to the Azure infrastructure that Contoso previously configured (as described in Deploy a migration infrastructure). Much of the infrastructure that’s required for this migration is already in place.

Create the foundation layer to support your migration project, you can align to Azure Landing Zones and prepare the foundation layer such as establishing hybrid connectivity (VPN and connectivity), Preparing identity (Active directory and Hybrid identity), Extending domain controller, DNS, Azure Firewall changes, Routing, etc.

Refer: Cloud Adoption Framework enterprise-scale landing zones in Azure – Cloud Adoption Framework | Microsoft Learn

• Migrate the data tier by using Azure Database Migration Service. This service connects to the on-premises VM that runs SQL Server via a site-to-site VPN connection between the Contoso datacenter and Azure. The service then migrates the database.
• Migrate the web tier by using Azure Migrate. The process requires preparing the on-premises VMware environment, configuring and enabling replication, and then migrating the VMs by having them fail over to Azure.

Migration of the web is covered in detail in the post: App modernization- re-host scenario – Rajeev Singh | Coder, Blogger, YouTuber (wpcomstaging.com)

We will now cover database migration in detail here.

Prerequisites

In order to migrate a database, the following prerequisites must be met.

Database Migration Service

Scenario steps

Once pre-requisites are completed, it’s time now to start the database migration work.

Step 1: Prepare a SQL-managed instance. 

Prepare and create SQL Managed instances.

• Create Subnet
• Set up virtual network
• Set up routing
• Create a managed instance

Step 2: Prepare Azure Database Migration Service. 

• Register the database migration provider, and create an instance.

• Set up a shared access signature (SAS) uniform resource identifier (URI) for the instance of Database Migration Service.

A SAS URI provides delegated access to resources in Contoso’s storage account so that Contoso can grant limited permissions to storage objects. Contoso sets up a SAS URI so that Azure Database Migration Service can access the storage account container to which the service uploads the SQL Server backup files.

• Create an Azure Database Migration Service project.

Step 3: Prepare Azure for the Migration and modernization tool. 

• Create a virtual network for the Azure VMs that are created during migration.
• Provision the Migration and modernization tool, part of Azure Migrate.

Step 4: Prepare on-premises VMware for the Migration and modernization tool. 

Prepare accounts for VM discovery and prepare to connect to Azure VMs after migration.

• A virtual network for the Azure VMs when they’re created during migration.
• The Azure Migrate appliance, is provisioned and configured.

Step 5: Replicate the on-premises VMs. 

• Sets up replication and starts replicating VMs to Azure Storage.

Step 6: Migrate the database via Azure Database Migration Service.

• Create a Database Migration Service project.

• Migrate the database

Step 7: Migrate the VMs with the Migration and Modernization tool. 

• Run a test migration to make sure everything’s working fine.
• Run a full migration to move the VM to Azure.

Clean up after migration

With the migration finished, an Azure VM runs the SmartHotel360 application and SQL Managed Instance hosts the SmartHotel360 database.

Now, perform these cleanup tasks:

• Remove the WEBVM machine from the vCenter Server inventory.
• Remove the SQLVM machine from the vCenter Server inventory.
• Remove WEBVM and SQLVM from local backup jobs.
• Update internal documentation to show the new location and IP address for WEBVM.
• Remove SQLVM from internal documentation. Alternatively, Contoso can revise the documentation to show SQLVM as deleted and no longer in the VM inventory.
• Review any resources that interact with the decommissioned VMs. Update any relevant settings or documentation to reflect the new configuration.

Review the deployment.

Now that the application is running, it must fully operationalize and be secured in Azure.

Security

Check the Azure VMs and the SQL-managed instance for any security issues in the implementation:

• Review the network security groups that control access for the VM. Network security groups help ensure that only traffic that’s allowed to the application can pass.
• Consider securing the data on the disk by using Azure Disk Encryption and Azure Key Vault.
• Enable threat detection on the managed instance. In the event of a threat, threat detection sends an alert to Contoso’s security team/service desk system to open a ticket.

Business continuity and disaster recovery

For business continuity and disaster recovery, take the following actions:

• Keep data safe. Backs up the data on the VMs by using the Azure Backup service.
• Keep applications up and running. Replicates the application VMs in Azure to a secondary region by using Site Recovery.

Licensing and cost optimization

• If Contoso has existing licensing for, take advantage of pricing with Azure Hybrid Benefit, Contoso converts the existing Azure VM.
• Contoso uses Azure Cost Management + Billing to ensure that the company stays within the budgets that IT leadership established.

Conclusion

In this article, we covered details on how we can plan and migrate the on-premises database to a SQL-managed instance by using Azure Database Migration Service.

In this post, we covered the migration approach and execution for the re-host scenario, migrating on-premises databases to Azure SQL-managed instances using Azure Database Migration Service.

Azure Database Migration Service offers a reliable and efficient approach for organizations looking to leverage the benefits of the cloud. By following the steps outlined in this article, organizations can successfully plan and execute the migration, thereby ensuring a seamless transition to the scalable and robust Azure SQL-managed instance environment.

References:

Rehost an on-premises application by migrating to Azure VMs and Azure SQL Managed Instance – Cloud Adoption Framework | Microsoft Learn