Azure SQL - General purpose service

Nguyen Dinh Phuong (DPS.FMS) 521 Reputation points
2022-06-28T08:29:14.817+00:00

You need to migrate an on-premises SQL Server database to Azure. The solution must ensure applications that access the SQL data are authenticated by Active Directory credentials.

Which Azure SQL architecture should you recommend?

Only select one answer.

Azure SQL Database with the General Purpose service tier

Azure SQL Database with the Business Critical service tier

Azure SQL Managed Instance with the General Purpose service tier

Azure SQL Database with the Hyperscale service tier

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. Alberto Morillo 33,176 Reputation points MVP
    2022-06-28T10:46:03.98+00:00

    Azure SQL Managed instance is the answer. Azure SQL Managed instance is the option that provides the most compatibility with SQL Server on-premise, it also supports Azure Active Directory authentication including server-level Azure AD login.

    Meanwhile, Azure SQL Database options supports Azure Active Directory authentication but only for Azure AD users.

    Read here for more information.

    3 people found this answer helpful.
    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Paulo "HellBoy" Abrasado 6 Reputation points
    2022-06-28T08:54:25.393+00:00

    I think all of these stuff can be connected as long as you have the db config file configured correctly. Please consider other some conditions like what kind of data being held on the db, how often do you access it, the scalability, etc.

    0 comments No comments

  2. 2023-08-19T19:19:43.54+00:00

    The answer is Azure SQL Managed instance.

    https://learn.microsoft.com/en-us/azure/dms/ads-sku-recommend

    0 comments No comments