Connecting to SQL Database By Using Azure Active Directory
With Azure SQL Database there is an option to connect by Azure AD account. It is one of the first citizen authentication type in Microsoft Management Studio 2016.
I suggest adding this types of authentication into RedGate products (especially into Compare and Data Compare).
Details here: https://azure.microsoft.com/cs-cz/documentation/articles/sql-database-aad-authentication/
Jiří Kanda
shared this idea
Hi!
As part of v12.4.9 release (frequent updates release), SQL Data Compare and SQL Compare now support Azure Active Directory authentication with integrated and password authentication methods. These options are available in the ‘Authentication’ dropdown in the ‘Database’ section of the ‘Edit project’ window. Note that this feature requires .NET 4.6 and adalsql.dll to be installed; see https://docs.microsoft.com/en-us/azure/sql-database/sql-database-aad-authentication-configure#configure-your-client-computers for more details
Let us know what you think!
-
Lee Diggins
commented
This is excellent news, many thanks for adding this. Can you tell me what plans you have for the other products to support this authentication, SQL Doc, Data Generator, Dependency Tracker?