
SQL Server Editions Compared
Standard and Enterprise are production editions. Express is free and has lower compute, memory, and database size limits. Developer is for development and testing, and SQL Server 2025 offers separate Developer editions for Standard and Enterprise features.
Enterprise vs. Standard vs. Express vs. Developer
| Edition | Use | Check before choosing |
|---|---|---|
| Enterprise | Production with Enterprise scale or features | Full Always On availability groups and online index create and rebuild |
| Standard | Production within Standard limits | SQL Server Agent and Basic Availability Groups. A Basic AG supports one database and two replicas. |
| Express | Small workloads and learning | Lower resource limits and no SQL Server Agent. Scheduled work needs an external scheduler. |
| Enterprise Developer | Development and testing with Enterprise features | SQL Server 2022 calls its Enterprise-featured development edition Developer. |
| Standard Developer | Development and testing with Standard features | Available in SQL Server 2025. Use it to test against the production edition’s feature set. |
| Evaluation | Enterprise evaluation | The deployment expires after 180 days. |
Express LocalDB is a lightweight, user-mode option for local development. For Web Edition, see the SQL Server 2022 matrix. For a production deployment, check the use rights in the Microsoft license terms and your agreement.
SQL Server 2025 and 2022 Standard and Express limits
| Limit | SQL Server 2025 | SQL Server 2022 |
|---|---|---|
| Standard compute per instance | Lesser of 4 sockets or 32 cores | Lesser of 4 sockets or 24 cores |
| Standard buffer pool per instance | 256 GB | 128 GB |
| Express relational database size | 50 GB per database | 10 GB per database |
| Express compute per instance | Lesser of 1 socket or 4 cores | Lesser of 1 socket or 4 cores |
A 20 GB database fits within the SQL Server 2025 Express size limit. Check compute, memory and scheduling requirements too. The same database exceeds the 10 GB limit of SQL Server 2022 Express. The buffer pool figures apply to that part of SQL Server memory. Analysis Services has its own limits.
Check the installed SQL Server edition before a move
SELECT SERVERPROPERTY('Edition') AS edition,
SERVERPROPERTY('ProductVersion') AS engine_build;Run the following in each application database and check reported features against the destination edition. Review instance-level dependencies separately, including SQL Server Agent jobs, availability groups, replication, and certificates used to restore encrypted backups.
SELECT feature_name
FROM sys.dm_db_persisted_sku_features;Microsoft’s upgrade matrix lists which edition changes Setup can perform in place. For other paths, check whether a side-by-side migration is supported and test the database restores and instance dependencies on the new edition.
Supported SQL Server 2025 edition changesMicrosoft’s database feature checkIdentify the exact buildPlan the upgradeCompare failover options
