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

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Schema Compare for SQL Server.
All Features

All features

Get acquainted with the rich features and capabilities of the Schema Compare in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Schema Compare for your business, request a demo to see it in action.
Ready to start using dbForge Schema Compare for SQL Server?