SQL Server Developer edition is functionally equivalent to Enterprise edition but is licensed only for development, test, and demonstration, and not for any production use.
From the provided context, the following points are supported:
Scope of permitted use / non‑production only
- SQL Server Developer edition “is licensed for use as a development and test system, not as a production server.” This applies across Windows and Linux and across supported versions (2017, 2019, 2022).
- Developer edition is described as “an ideal choice for people who build and test applications,” reinforcing that its intended use is development, testing, and demonstration only, not serving live business workloads.
Production boundary (what makes an environment production)
The context does not provide a formal, exhaustive definition of “production,” but it does clearly state the following boundary:
- Developer edition “cannot be used for production workloads.”
- Production workloads are those where SQL Server is used “as a production server” (for example, supporting live workloads, business operations, or end‑user services).
The context does not further break down characteristics such as SLAs, end‑user access, or workflow participation, so no additional formal criteria can be stated beyond “not as a production server / not for production workloads.”
HA / DR and production‑like configurations
- The context does not explicitly address HA/DR or “cold standby” scenarios for Developer edition.
- What is stated is that Developer edition is licensed strictly for development, test, and demonstration, and “cannot be used for production workloads.”
- Therefore, any HA/DR configuration that is part of a production workload or intended to serve production traffic would fall outside the permitted Developer edition use. The context does not provide a specific rule for “cold standby” or “not capable of serving production traffic,” so no further formal distinction can be drawn from the provided material.
Integration with production systems / part of a production workload path
- The context does not define “part of a production workload path” or explicitly discuss linked servers, data flows, or hybrid architectures in relation to Developer edition.
- The only clear boundary given is that Developer edition is not licensed “as a production server” and “cannot be used for production workloads.” Any integration that constitutes using that instance as part of a production workload would therefore be outside permitted use, but the context does not provide more granular criteria.
Reporting and analytics against live production data
- The context does not explicitly address reporting/analytics scenarios or whether querying live production data automatically constitutes production use.
- The only enforceable statement from the context is that Developer edition cannot be used for production workloads or as a production server. No further formal rule on reporting/analytics can be derived from the provided material.
Longevity of non‑production use
- The context explicitly supports long‑term non‑production use:
- For ESUs and licensing, it states that “development and test instances licensed with Microsoft Developer edition licenses or Visual Studio subscriptions” can be covered “for no additional cost” and does not impose a time limit on non‑production use.
- Developer edition is presented as a standing option for development/test; there is no indication that multi‑year non‑production use changes its licensing status, as long as it remains non‑production.
Developer edition in non‑production with ESUs / Azure Arc
- For SQL Server enabled by Azure Arc and ESUs:
- “SQL Server Developer edition is free and can be used in any Azure subscription.”
- Azure Extension for SQL Server “detects it and reports the usage via a $0 Dev edition meter” and “doesn’t generate the ESU charges,” while still installing ESUs when the ESU subscription is active.
- If Developer edition is colocated on the same host with Standard or Enterprise, “the latter takes billing precedence as a production edition” and ESU charges follow the production edition.
- This reinforces that Developer edition itself is treated as non‑production and free, even when present on a host that also runs production editions.
Mixed‑edition instances on the same server or VM
From the context:
- Developer edition definition (Windows and Linux, all listed versions):
- “Includes all the functionality of Enterprise edition, but is licensed for use as a development and test system, not as a production server.”
- Azure Arc / ESU behavior:
- “If the Developer edition is colocated on the same host with an instance of the Standard or Enterprise edition, the latter takes billing precedence as a production edition. The active ESU subscription generates the ESU charges according to that edition.”
From these points, the following positions are supported:
- Installing Developer edition on a server or VM that also hosts Standard or Enterprise does not change Developer edition’s licensing restriction: it remains licensed only for development, test, and demonstration, not for production workloads.
- The presence of a licensed Standard or Enterprise instance on the same VM does not grant production rights to a Developer edition instance. The context consistently treats Developer edition as non‑production only.
- The context does not explicitly restate per‑instance licensing rules for Standard/Enterprise in mixed‑edition scenarios, but it does state that Developer edition is non‑production only and that production editions (Standard/Enterprise) are what drive production metering and ESU billing on that host.
Non‑production benefits when production is licensed via Azure Arc / ESUs
- When production SQL Server is licensed and managed via Azure Arc, non‑production use can be free in two ways:
- Use SQL Server Developer edition: detected and reported via a $0 Dev edition meter, no ESU charges; still receives ESUs when the subscription is active.
- Use an Azure dev/test subscription: “The SQL Server meters in a dev/test subscription are nullified,” and the same applies to ESU meters.
- For ESU SKUs via Commercial Licensing: “development and test instances licensed with Microsoft Developer edition licenses or Visual Studio subscriptions” can be covered “for no additional cost.”
These statements reinforce that Developer edition is explicitly intended and supported for non‑production development and test, including long‑term use and in environments that mirror production, as long as they are not used as production servers.
References:
- SQL Server Extended Security Updates enabled by Azure Arc
- Manage licensing and billing of SQL Server enabled by Azure Arc
- Editions and supported features of SQL Server 2017
- Lifecycle FAQ - Extended Security Updates
- Editions and supported features of SQL Server 2017 on Linux
- Editions and supported features of SQL Server 2022 on Linux
- Editions and supported features of SQL Server 2019 on Linux
- SQL Server Developer Edition usage for local development environment - Microsoft Q&A Details
- SQL Server Developer - Microsoft Q&A