How to register Schema Compare as an Azure Active Directory application

To connect to an Azure database with the Universal with MFA support authentication, you should register dbForge Schema Compare for SQL Server as an Azure Active Directory application and set permissions. During the registration, an application ID will be generated automatically.

To register Schema Compare as an Azure Active Directory application:

1. Sign in to the Azure portal.

2. In Azure services, click Azure Active Directory and select App registrations > New registration.

Create a registration for dbForge Schema Compare for SQL Server

3. On the Register an application page, enter dbForge Schema Compare in the Name field and click Register.

Enter dbForge Schema Compare as an application name

Note

After Schema Compare has been registered as an application, the application ID is generated automatically. It is a unique and unchangeable identifier for dbForge Schema Compare for SQL Server. You need to copy and save it to connect dbForge Schema Compare for SQL Server to the Azure database.

4. On the page that opens, click Add a Redirect URI.

Add a Redirect URI

5. On the dbForge Schema Compare > Authentication page, click Add a platform and then click Mobile and desktop applications.

Define an authentication type

6. In the Configure Desktop + Devices window, select https://login.microsoftonline.com/common/oauth2/nativeclient as a redirect URI and click Configure.

7. On the Authentication page, switch to the Advanced settings section, turn the toggle switch next to Allow public client flows to Yes, and then click Save.

8. In the Azure portal, click API permissions and then click Add a permission.

9. In the Request API permissions window that opens, switch to the APIs my organization uses tab and start typing Azure SQL Database in the Search field.

10. From the drop-down list, select Azure SQL Database.

Add API permission

11. Click Delegated permissions, select the user_impersonation check box, and then click Add permissions.

Add permissions