Azure SQL - General purpose service

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

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
No comments
{count} votes

Accepted answer
  1. answered 2022-06-28T10:46:03.98+00:00
    Alberto Morillo 24,631 Reputation points Microsoft MVP

    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.

    No comments

1 additional answer

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

    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.

    No comments