Migrate On prem to Azure Sql Managed instance

Shreedevi Sendarapatti Ramamoorthy 0 Reputation points
2024-04-23T17:46:35.1533333+00:00

I am planning to migrate the on-premises SQL server on virtual machines to an Azure SQL managed instance.

I am looking for a migration plan that can help with the above migration, which will list the compatibility and options to move the data without downtime, encrypt the data both in-transit and at rest.

When I checked, Azure’s Database Migration Service (DMS) can help move the databases without downtime, especially for read-heavy workloads.

It will be more helpful if someone with similar requirements has used any of the most cost-effective options and lists any other tools or services that can help with the assessment of the current database - compatibility issues , detection of partially supported or unsupported features that are currently in use by the source SQL Server instance, performance data,etc

Azure Database Migration service
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
966 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,755 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 27,642 Reputation points Microsoft Employee
    2024-04-23T19:01:49.98+00:00

    @Shreedevi Sendarapatti Ramamoorthy Welcome to Microsoft Q&A thanks for posting your question.

    Here are the options that usually come to my mind to recommend, I would recommend you to explore these options, in order to see what option fits better.

     LRS: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/log-replay-service-overview?view=azuresql

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

     Transactional replication, https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/replication-transactional-overview?view=azuresql might be the option.

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

    Please let me know if you need more information.

    Regards

    Geetha 

    0 comments
  2. LucyChen-MSFT 1,045 Reputation points Microsoft Vendor
    2024-04-24T07:18:10.94+00:00

    Hi @Shreedevi Sendarapatti Ramamoorthy,

    Thanks for your information.

    1. It is unlikely that you'll have any compatibility or feature parity issues if the source and target SQL Server versions are the same.
    2. Before migration, it's a good practice to run an assessment of your SQL Server databases if the versions are different. We recommend the Azure Migrate to discover and assess single databases or at scale from different environments. This extension collects performance data from your source SQL Server instance to provide right-size Azure recommendation that meets your workload's performance needs with minimal cost. You can see this article to learn more. NOTE: Please ensure the logins used to connect the source SQL Server are members of the sysadmin server role or have CONTROLSERVER permission.
    3. There are many migration methods to migrate your databases. Please read this article carefully and choose appropriate method, the steps of each method are list detailed in this article.
    4. We recommend the DMS first. It provides online and offline migration modes. You can check the limitations between them to choose the better method.
    5. Not all SQL Server versions support all compatibility modes. Check your target SQL Server version supports your chosen database compatibility. We recommend the DMA to assess on-premises SQL Server instances and understand the gaps between the source and target versions.

    Hope my answer can help you well.

    Best regards,

    Lucy Chen

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    https://docs.microsoft.com/en-us/answers/support/email-notifications