Quick verdict
Use Express when the database will run in production for free: a small web, desktop or departmental application that fits 50 GB per database (SQL Server 2025) and the memory and core caps, without SQL Server Agent. Use a Developer edition for development, testing and staging of an application that will run on a paid edition in production: Standard Developer if production will be Standard, Enterprise Developer if it will be Enterprise. Never put a Developer edition into production; its licence does not allow it.
SQL Server Express is the free entry-level edition. Microsoft's downloads page describes it as "ideal for development and production for desktop, web, and small server applications". From SQL Server 2025, Express includes all the features of the discontinued Express with Advanced Services, including Full Text Search, SQL Server Data Tools and machine learning integration, and its maximum database size rose to 50 GB. LocalDB, a lightweight user-mode version of Express, is aimed at developers who want a zero-configuration local database.
SQL Server Developer changed in SQL Server 2025. The single Developer edition of earlier versions, which had all Enterprise features, is replaced by two free editions. Enterprise Developer includes all the functionality of Enterprise and is, in Microsoft's words, "functionally equivalent to Developer edition in previous versions". Standard Developer includes all the functionality of Standard, so you can build and test against exactly what you will deploy on Standard, and use it as a staging environment to certify an upgrade to SQL Server 2025 Standard. Both are licensed "for use as a development and test system, not as a production server".
Side by side
| Aspect | Express | Developer |
|---|---|---|
| Cost | Free | Free (Standard Developer and Enterprise Developer) |
| Production use | Allowed | Not allowed: development and test only |
| Feature set (2025) | Express column of the editions page, now including former Advanced Services features | Standard Developer = Standard features; Enterprise Developer = Enterprise features |
| Compute per instance (2025) | Lesser of 1 socket or 4 cores | As the matching edition: Standard limits (lesser of 4 sockets or 32 cores) or Enterprise (operating system maximum) |
| Buffer pool memory (2025) | 1,410 MB | 256 GB (Standard Developer) or operating system maximum (Enterprise Developer) |
| Maximum database size (2025) | 50 GB per database (10 GB in 2022 and earlier) | 524 PB |
| SQL Server Agent | Not included | Included |
| High availability features | None (no log shipping, clustering or availability groups) | Basic availability groups (Standard Developer) or full availability groups (Enterprise Developer), for testing |
| Choice in SQL Server 2022 | Express (10 GB) or Express with Advanced Services | One Developer edition with Enterprise features |
| Main trade-off | Production licence, but small caps and no Agent | Full features, but no production use at all |
Key differences
The licence decides, not the features
Both editions are free downloads, which is why they are confused. The deciding question is where the database runs. Express is licensed for production. The Developer editions are licensed only for development and test: Microsoft describes each as "licensed for use as a development and test system, not as a production server", and the downloads page describes Developer as being "for non-production development and testing". If real users or live business data depend on the server, it is production, and a Developer edition is the wrong licence however small the workload. The usual pattern is a Developer edition on developer machines and test servers, and Express, Standard or Enterprise in production.
Limits that only Express has
According to Microsoft's SQL Server 2025 scale limits table, Express uses at most the lesser of 1 socket or 4 cores, 1,410 MB of buffer pool memory, 352 MB each for the columnstore segment cache and memory-optimized data per database, and 50 GB per relational database. Microsoft's editions page tells readers to use the Standard column for Standard Developer and the Enterprise column for Enterprise Developer, so the Developer editions carry the paid editions' limits: the lesser of 4 sockets or 32 cores and 256 GB of buffer pool for Standard Developer, and operating system maximums for Enterprise Developer, with a 524 PB maximum database size for both.
Express also lacks SQL Server Agent, Database Mail, log shipping, failover clustering, availability groups, backup compression, Transparent Data Encryption, Resource Governor and change data capture. If your production target is Express, develop and test on Express (or LocalDB) as well, so you meet those limits during development rather than in production.
Standard Developer or Enterprise Developer
Before SQL Server 2025 there was only one Developer edition, with every Enterprise feature. That made it easy to build an application that quietly relied on an Enterprise-only feature, such as online index rebuilds or batch mode on rowstore, and then deploy it to Standard. SQL Server 2025 adds Standard Developer to close that gap: it has Standard's features and limits, so test results match a Standard production server. Choose Enterprise Developer when production runs Enterprise, or when you are evaluating whether Enterprise features are worth buying. See Standard vs Enterprise for the feature differences.
For upgrades, Microsoft's SQL Server 2025 upgrade page lists Developer edition installations of SQL Server 2014 SP3 through 2022 as upgradable to Enterprise Developer, Standard Developer or Enterprise in SQL Server 2025, and lists edition upgrades from Developer to Standard or Enterprise, and from Express to Standard, Enterprise or Developer, within SQL Server 2025.
Pricing and licensing
Express, Standard Developer and Enterprise Developer are all free downloads; Microsoft's SQL Server 2025 pricing sheet lists "Developer: Standard and Enterprise" and Express as free, with no licensing model.
The cost appears when an application developed on a Developer edition goes to production on a paid edition. Listed on Microsoft's SQL Server 2025 pricing sheet in October 2026, in US dollars, as open no-level estimated retail prices: Standard USD 3,945 per 2-core pack (or USD 989 per server plus USD 230 per CAL), and Enterprise USD 15,123 per 2-core pack. If production can stay within the Express limits, it costs nothing in licences.
Pricing checked on the vendors' official pages on 7 October 2026. Prices change; confirm before buying.
Where each one leads
Express strengths
- Free and licensed for production use
- 50 GB per database in SQL Server 2025, up from 10 GB
- Includes the former Advanced Services features (Full Text Search, SSDT, machine learning integration) from SQL Server 2025
- LocalDB option for lightweight local development
- Clear upgrade path to Standard or Enterprise without code changes
Developer strengths
- Free, with the complete feature set of Standard or Enterprise
- No Express caps on database size, memory or cores
- Standard Developer matches a Standard production server, new in SQL Server 2025
- Includes SQL Server Agent and availability group features for realistic testing
- Enterprise Developer lets you evaluate Enterprise features before buying
Limitations
Express limitations
- Capped at the lesser of 1 socket or 4 cores and 1,410 MB of buffer pool
- 50 GB per database in 2025 (10 GB in 2022 and earlier)
- No SQL Server Agent, Database Mail or high availability features
Developer limitations
- Licensed for development and test only; never for production
- Testing on Enterprise Developer can hide Enterprise-only dependencies if production is Standard
- Moving to production requires buying a paid licence or fitting within Express
When to choose each
Choose Express if
- The database will serve real users and you want no licence cost
- Each database will stay under 50 GB on SQL Server 2025
- You are shipping a desktop or small server application that embeds a local database
- You can schedule backups and maintenance outside SQL Server
Choose Developer if
- You are developing or testing an application that will run on Standard or Enterprise
- You need SQL Server Agent, availability groups or other paid-edition features in a test environment
- You want to evaluate Enterprise features before buying (Enterprise Developer)
- You want a staging server that matches Standard exactly (Standard Developer)
When neither is right
- Production has outgrown Express: you need a paid licence. See Express vs Standard and Standard vs Enterprise.
- You want a free production database without the Express caps: compare an open source engine in SQL Server vs PostgreSQL or MySQL vs SQL Server.
- You only need a short trial of Enterprise features on a server you may later license: Microsoft also offers an Evaluation edition with Enterprise features for 180 days.
- You would rather not run SQL Server yourself: see Azure SQL Database vs SQL Server.
Final recommendation
These editions are not rivals; they cover different stages. Express is the free edition you may put into production, within its SQL Server 2025 limits of 50 GB per database, 1,410 MB of buffer pool and 4 cores, and without SQL Server Agent. The Developer editions are the free editions for building and testing, with every feature of the paid edition they mirror, and they must never run production. In SQL Server 2025, pick Standard Developer if production will be Standard and Enterprise Developer if it will be Enterprise, so your tests reflect what you will deploy. If you are still on SQL Server 2022, remember that Express is limited to 10 GB per database and there is only one, Enterprise-equivalent, Developer edition.
Frequently asked questions
Can I use SQL Server Developer edition in production?
No. Microsoft licenses Standard Developer and Enterprise Developer for use as a development and test system, not as a production server. For a free production database use Express, or buy Standard or Enterprise.
What is the difference between Standard Developer and Enterprise Developer?
Both are free and for development and test only. Standard Developer includes all Standard edition features; Enterprise Developer includes all Enterprise edition features and is functionally equivalent to the Developer edition of earlier versions. They are new in SQL Server 2025.
What are the SQL Server 2025 Express limits?
The lesser of 1 socket or 4 cores, 1,410 MB of buffer pool memory per instance, 352 MB for the columnstore segment cache and for memory-optimized data per database, and 50 GB per database. SQL Server 2022 Express had the same compute and memory limits but a 10 GB database limit.
Which free edition should I develop against?
Develop against the edition you will run in production: Express or LocalDB if production is Express, Standard Developer if it is Standard, and Enterprise Developer if it is Enterprise. That way limits and missing features show up during testing.
Can I move a database from Developer to Express?
Microsoft's SQL Server 2025 edition upgrade table does not list an edition upgrade from Developer to Express. If you move a database to Express another way, first check that it is under 50 GB and uses no features that the editions page marks as unavailable in Express.
Sources
- Microsoft Learn: Editions and supported features of SQL Server 2025
- Microsoft Learn: Editions and supported features of SQL Server 2022
- Microsoft Learn: What's new in SQL Server 2025 (new developer editions)
- Microsoft: SQL Server downloads (Express and Developer)
- Microsoft: SQL Server 2025 pricing sheet (PDF)
- Microsoft Learn: Supported version and edition upgrades (SQL Server 2025)
Checked October 2026.
How we research comparisons: our editorial method.