Migrating on prem SQL 2012 database to Azure Managed instance with Always on feature enable

Ken 21 Reputation points
2021-10-19T02:46:43.167+00:00

Hi There,

We are in process of building POC for Azure PAAS stuffs. Migrating on prem SQL 2012 databases to Azure SQL or SQL manged instances with Always ON feature enabled.
I've read few articles and bit confused. still don't have clarity about Always On features in both Azure SQL and SQL manged instances .
"The SQL Server high-availability features Always On failover cluster instances and Always On availability groups become obsolete on the target SQL managed instance. High-availability architecture is already built into both General Purpose (standard availability model) and Business Critical (premium availability model) service tiers for SQL Managed Instance. The premium availability model also provides read scale-out that allows connecting into one of the secondary nodes for read-only purposes"

What does it mean? Could you please assist me on that? Also, what needs to be done from DB migration from on-prem to Azure PAAs.

What are the key pointswe need to consider before we migrate? I've gone through many articles and looks like we should have strong networking skills in order to migrate.

Thanks in adavance.

Regards,
Ken

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anurag Sharma 17,576 Reputation points
    2021-10-19T12:04:00.207+00:00

    Hi @Ken , welcome to Microsoft Q&A forum.

    SQL Server Always on feature talks about high availability of the database and also talks about how to recover in case of database failure. With Azure SQL Database and Azure SQL managed instance these features are already available as part of high availability models and failover groups. Please refer to below document that talks about these features in details:

    High availability for Azure SQL Database and SQL Managed Instance

    Use auto-failover groups to enable transparent and coordinated failover of multiple databases

    For migrating on-premise SQL Server to Azure, its good to know each and every details but in real time even if we don't need to go through these minute details it is totally fine as we have already available detailed documentation that has step by step process of migration from on-premise to Azure.

    Azure SQL Managed Instance:

    Compare migration options

    In this article, you can check Azure Database Migration Service as an example to check the migration process. There are other ways as well. Please check the versions supported before you choose any option here.

    Azure SQL:

    SQL Server database migration to Azure SQL Database

    Please check these links and let us know if you have any queries related to this, or if you face any issues while migrating. These documents are bit lengthy, but we are there to assist you in case of any questions.