Ken-9235 avatar image
0 Votes"
Ken-9235 asked AnuragSharma-MSFT commented

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

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.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Ken-9235, just wanted to check if you need any other details. If answer helped, you can choose to mark it 'Accept Answer'

0 Votes 0 ·

1 Answer

AnuragSharma-MSFT avatar image
0 Votes"
AnuragSharma-MSFT answered KumariMeenakshy-3147 commented

Hi @Ken-9235, 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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you Anurag for replying.

0 Votes 0 ·