SQL failover cluster instance migration to cloud

Veeramalla Rakesh - (Digital) 41 Reputation points
2023-03-16T05:58:33.8733333+00:00

We have requirement of migrating SQL failover cluster instance to Azure using lift and shift preferably (without much re-engineering or re-architecting)

  1. SQL cluster with 2 nodes. (OS - windows 2012 standard, SQL - 2012 sp4)
  2. Four SQL cluster instances(named) installed on it.
  3. SQL Instances SSIS, SSAS, SSRS of 2008 version

We are planning to move all roles to one node, demote the other node from cluster, shutdown the node and migrate node to azure.

Problem could be there are four sql failover cluster instances installed and how it will function same as existing once we migrate the SQL server to Azure.

Azure Database Migration service
Azure SQL Database
Azure Migrate
Azure Migrate
A central hub of Azure cloud migration services and tools to discover, assess, and migrate workloads to the cloud.
722 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
962 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Limitless Technology 43,986 Reputation points
    2023-03-16T14:59:30.2733333+00:00

    Hello there,

    The key factors to consider when you're evaluating migration options are:

    Number of servers and databases

    Size of databases

    Acceptable business downtime during the migration process

    Azure SQL Database is a recommended target option for SQL Server workloads that require a fully managed platform as a service (PaaS). SQL Database handles most database management functions. It also has built-in high availability, intelligent query processing, scalability, and performance capabilities to suit many application types

    Hope this resolves your Query !!

    --If the reply is helpful, please Upvote and Accept it as an answer--


  2. GeethaThatipatri-MSFT 27,887 Reputation points Microsoft Employee
    2023-03-22T19:30:54.6833333+00:00

    @Veeramalla Rakesh - (Digital)

    Given the fact this architecture is already using AGs, you might want to take a look at the MI link in case your target is Azure SQL MI:

    https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-feature-overview?view=azuresql

    Alternatively, depending on the target, you can consider DMSv2 to perform an online migration to Azure SQL. This type of migration leverages existing backups stored in Azure blob storage or a network share. The advantage of an online migration is that it will continuously restore any backups to the target while maintaining the source online. Then you can plan the cutover whenever you are ready to minimize downtime.

     Here you have the tutorials for MI and VM targets:

    https://learn.microsoft.com/en-us/azure/dms/tutorial-sql-server-managed-instance-online-ads

    https://learn.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-virtual-machine-online-ads

    Please let us know if this helps.

    Regards

    Geetha

     

    0 comments No comments