azuresql-db-from-sql-server
Installation
SKILL.md
Migrate from the SQL Server image to Azure SQL Developer
This skill converts an existing local SQL Server setup (the SQL Server image
mcr.microsoft.com/mssql/server) into the Azure SQL Database container so
local dev matches Azure SQL Database behavior. The two are not the same engine:
| SQL Server image | Azure SQL Developer | |
|---|---|---|
| Image | mcr.microsoft.com/mssql/server |
sqldbpreview-dpgaeqhmgphzd4bk.azurecr.io/azure-sql/db-dev:latest |
SERVERPROPERTY('EngineEdition') |
2/3/4/8 | 5 |
SERVERPROPERTY('Edition') |
e.g. 'Developer Edition' | 'SQL Azure' |
| DB model | one instance, many DBs, USE works |
master for provisioning only; user DB for work; a user-database (SDS) session returns Msg 40508 on USE, exactly as in the cloud; a master connection is a non-SDS provisioning session where the filter is not enforced |
If a project is using the SQL Server image but wants Azure-faithful local dev, stop and switch to Azure SQL Developer. This skill is self-contained; for full container detail see the azuresql-db-container skill.