DvSchemaSync supports different authentication methods for Dataverse and Azure SQL connections. This page explains your options and when to use each.
Dataverse Authentication
Dataverse connections require Microsoft Entra App Registration authentication. This is the only supported method.
Required credentials:
• Client ID (Application ID)
• Client Secret
• Tenant ID (Directory ID)
Azure SQL Authentication
Azure SQL connections support two authentication methods:
Option 1: SQL Server Authentication
Uses a SQL username and password created on the database server.
Pros: Simple to set up, works independently of Entra
Cons: Separate credential to manage, less secure than Entra
Option 2: Microsoft Entra App Registration
Uses the same App Registration as your Dataverse connection.
Pros: Single identity, centralized management, more secure
Cons: Requires additional Azure SQL configuration
Recommendation
✓ Best Practice: Use Microsoft Entra App Registration for both Dataverse and Azure SQL. This provides a single identity to manage, better security, and centralized access control.
Comparison Summary
| Feature | SQL Authentication | Entra App Registration |
|---|---|---|
| Setup complexity | Simple | Moderate |
| Security | Good | Better |
| Credential management | Separate credentials | Single identity |
| Audit logging | SQL logs only | Entra + SQL logs |