Connect DB with Azure MFA from visual studio to compare project solution against Azure DB?

Viewed 597

I am trying to compare my database project (.sln) with a Azure DB which can be connected using Azure MFA option. I can compare DB vs DB with SSMS and DB/bacpac vs DB/bacpac (Azure Data Studio+Schema compare extn.). Is there any way to connect it from visual studio to compare .sln(DB Project Solution) vs DB? Any VS extensions ?

SSMS - Working Fine

SSMS - Working Fine

From Visual Studio 2017 Server Explorer - No option From Visual Studio 2017 Server Explorer - No option

1 Answers

SSMS and SqlPackage.exe are the only tools currently enabled for MFA through Active Directory Universal Authentication.

Please ref: Universal Authentication limitations

Hope this helps.

Related