Azure SQL Edge is a small-footprint deployment option of the SQL Server database engine that may help address device constraints that prevent deploying the full SQL Server product on such devices.
Azure SQL Database previews an emulator that can help developers create and test databases locally if they can accept the limitations.
SQL Server remains Microsoft’s preferred structured data technology; however, several open-source Azure services now compete with SQL Server, and one is available on-premises.
The chart compares Microsoft’s on-premises and hosted database management offerings, their query languages, and the data types they support.
Sidebar explains the various data types and technologies used in Microsoft database management offerings.
Microsoft's database management landscape includes on-premises and cloud solutions with proprietary and open-source products that are designed for all enterprise data types and workloads.
Administrators may need to use both Azure Data Studio and SQL Server Management Studio to manage SQL Server deployments for the next few years.
Chart compares SQL Server database on-premises with SQL Server in Azure VMs, Azure SQL offerings, and Azure Synapse Analytics.
SQL Server database PaaS and cloud offerings provide alternatives to on-premises deployments, but choosing a destination includes trade-offs, and comparing costs may be difficult.
Azure SQL Edge is a small-footprint SQL Server database engine deployment option for IoT devices and other edge scenarios.
Roadmap for Azure SQL Edge, a small-footprint deployment option optimized for low-powered devices, gateways, or edge servers running near Internet of Things (IoT) devices.