You are viewing a free preview of this lesson.
Subscribe to unlock all 10 lessons in this course and every other course on LearningBro.
Azure SQL Managed Instance is a fully managed deployment option for SQL Server that provides near-100% compatibility with the on-premises SQL Server engine. It is designed specifically for organisations that need to migrate existing SQL Server workloads to Azure without rewriting applications.
Azure SQL Database is excellent for new cloud-native applications, but some existing workloads rely on SQL Server features that Azure SQL Database does not support. SQL Managed Instance bridges this gap:
| Feature | Azure SQL Database | SQL Managed Instance |
|---|---|---|
| SQL Server Agent | Not available | Supported |
| Cross-database queries | Not available | Supported |
| CLR integration | Not available | Supported |
| Linked servers | Not available | Supported |
| Service Broker | Not available | Supported |
| Database mail | Not available | Supported |
| Native backup/restore | Not supported | Supported |
| VNet deployment | Firewall rules / Private Endpoint | Native VNet integration |
| Instance-scoped features | Limited | Full instance scope |
Subscribe to continue reading
Get full access to this lesson and all 10 lessons in this course.