SQL Server 2022 Express vs Developer vs Standard: Which Edition Do You Need?
Microsoft gives away two editions of SQL Server 2022: Express and Developer. Both are free downloads, so a common question is whether a small business needs to buy SQL Server 2022 Standard at all.
The answer depends on what each free edition is allowed to do and what it’s able to do. Developer has every feature but can’t be used in production. Express can run real applications but has hard limits on size, memory, and processing power. Standard is the paid edition for production databases that have outgrown Express.
This guide explains each edition using Microsoft’s own documentation, so you can tell which one fits your situation.
The quick answer
- SQL Server 2022 Developer is free and includes all Enterprise edition features, but Microsoft licenses it for development, test, and demonstration only. It can’t run a production database.
- SQL Server 2022 Express is free and can run small applications, but each instance is limited to the lesser of 1 socket or 4 cores, 1,410 MB of buffer pool memory, and 10 GB per database. It doesn’t include SQL Server Agent.
- SQL Server 2022 Standard is the paid edition for production. It scales to the lesser of 4 sockets or 24 cores, 128 GB of buffer pool memory, and databases up to 524 PB, and adds SQL Server Agent, backup compression, encryption, and high-availability options.
Side-by-side comparison
All figures below come from Microsoft’s SQL Server 2022 editions documentation and licensing guide.
| Express | Developer | Standard | |
|---|---|---|---|
| Cost | Free download | Free download | Paid license |
| Allowed in production | Yes | No (dev, test, and demo only) | Yes |
| Features | Entry-level subset | Everything in Enterprise | Business-grade subset |
| Compute per instance | Lesser of 1 socket or 4 cores | Operating system maximum | Lesser of 4 sockets or 24 cores |
| Buffer pool memory per instance | 1,410 MB | Operating system maximum | 128 GB |
| Maximum database size | 10 GB | 524 PB | 524 PB |
| SQL Server Agent (scheduled jobs) | No | Yes | Yes |
| Backup compression and encrypted backup | No | Yes | Yes |
| Transparent data encryption (TDE) | No | Yes | Yes |
| Log shipping | No | Yes | Yes |
| Failover cluster instances | No | Yes | Yes (2 nodes) |
| Basic availability groups | No | No (has full Always On availability groups) | Yes |
| Database Mail | No | Yes | Yes |
SQL Server 2022 Developer: every feature, but not for production
Microsoft describes Developer as a full-featured version of SQL Server that includes all the functionality of Enterprise edition, licensed as a development and test system rather than a production server.
What the licensing guide allows:
- It’s free. Microsoft made Developer a free product in 2016, and the SQL Server 2022 pricing page lists it as a free download.
- Install it on as many devices as you need, as long as they’re used for development, testing, or demonstration.
- No production use. Developer “may not be used in a production environment.”
Microsoft’s guide also defines what counts as production. It’s any environment that end users access for more than gathering feedback or acceptance testing. Microsoft also lists these as production:
- an environment that connects to a production database
- an environment that supports disaster recovery or backup for production
- a server that’s used for production some of the time, such as during busy periods
Microsoft also says any test data used during development must be removed before you deploy the software to production.
Developer is a good fit for: programmers building or testing an application, IT staff trying out features before a rollout, and training or demo machines.
It isn’t a fit for: your company’s live accounting, CRM, inventory, or line-of-business database, even if only a few people use it.
SQL Server 2022 Express: free, with hard limits
Microsoft describes Express as the entry-level, free database, ideal for learning and for building desktop and small server data-driven applications. Microsoft’s licensing guide calls it “freely downloadable and distributable,” and Microsoft doesn’t restrict it to non-production use the way it does Developer.
The catch is the scale limits per instance:
- Compute: the lesser of 1 socket or 4 cores
- Buffer pool memory: 1,410 MB
- Database size: 10 GB per database
Express also leaves out several features that businesses tend to rely on:
- SQL Server Agent, which runs scheduled jobs such as nightly backups and maintenance
- Backup compression and encrypted backups
- Transparent data encryption (TDE)
- Log shipping, failover cluster instances, and basic availability groups
- Database Mail
Express also comes in a variant called Express with Advanced Services, which adds features such as full-text search and Reporting Services (up to 4 GB of memory). LocalDB is a lightweight version of Express for developers that runs in user mode with a zero-configuration install.
Express is a good fit for: small desktop or departmental applications, an app from a software vendor that ships with Express, small websites, and learning SQL Server.
SQL Server 2022 Standard: the production edition for most businesses
Microsoft describes Standard as delivering “a balance of performance, security, and affordability for businesses that need enterprise-class capabilities without the complexity.”
Compared with Express, Standard gives you:
- Room to grow: the lesser of 4 sockets or 24 cores, 128 GB of buffer pool memory, and databases up to 524 PB.
- Automation: SQL Server Agent for scheduled backups, index maintenance, and other jobs.
- Data protection: backup compression, encrypted backups, and transparent data encryption.
- High availability: log shipping, two-node failover cluster instances, and basic availability groups (two replicas, one database each).
How Standard is licensed
Standard can be licensed two ways, according to Microsoft:
- Server + CAL: one license for each server running SQL Server, plus a SQL Server CAL for every user or device that accesses it.
- Per Core: you license the server’s cores and don’t need CALs, which suits websites, external users, or user counts that are hard to track.
For the details and worked examples, see our guide to SQL Server 2022 licensing.
Signs you’ve outgrown Express
Choose Standard when one or more of these is true:
- A database is getting close to 10 GB, or you expect it to grow past that.
- Queries are slow under load because the instance can use only 1,410 MB of buffer pool memory and up to 4 cores, even on a bigger server.
- You need scheduled jobs through SQL Server Agent, such as automatic nightly backups.
- You need encryption for data at rest (TDE) or for backups.
- You need high availability, such as a failover cluster or a standby copy of the database.
- You were using Developer for a system that’s now live. Once end users rely on it, it’s production, and Developer can’t be used.
Which edition should you choose?
| Your situation | Edition |
|---|---|
| Building or testing an app on your own machine | Developer (free) |
| A test or staging server that doesn’t connect to production data | Developer (free) |
| A small app or vendor package with a database well under 10 GB | Express (free) |
| A live business database that’s growing, or needs scheduled backups | Standard |
| A database that needs encryption at rest or failover | Standard |
| Mission-critical workloads beyond Standard’s limits | Enterprise (request a quote) |
A note on SQL Server 2025
Microsoft’s downloads page now offers the SQL Server 2025 versions of Express and Developer. Microsoft’s SQL Server 2025 documentation lists an Express database size limit of 50 GB, and Developer now comes in two flavors, Enterprise Developer and Standard Developer. If you’re choosing SQL Server 2025 instead, check Microsoft’s 2025 editions page for its limits. Everything else in this guide applies to SQL Server 2022.
Shop SQL Server
- SQL Server 2022 Standard (server license for the Server + CAL model; for Per Core, request a quote)
- SQL Server 2022 User CAL (for Server + CAL licensing)
- Browse all SQL Server licenses
Express and Developer are free from Microsoft’s SQL Server downloads page.
Licensing several servers, a per-core setup, or Enterprise edition? Request a quote and tell us how many servers or VMs you have, the core count of each, and how many users or devices connect.
Frequently asked questions
Both are free. Developer includes every Enterprise edition feature with no scale limits, but Microsoft licenses it for development, test, and demonstration only. Express can be used in production but is limited to the lesser of 1 socket or 4 cores, 1,410 MB of buffer pool memory, and 10 GB per database.
Microsoft lists a maximum relational database size of 10 GB for SQL Server 2022 Express, including Express with Advanced Services. Standard and Enterprise support databases up to 524 PB.
Yes. Microsoft calls Express freely downloadable and distributable, and doesn’t restrict it to non-production use the way it does Developer. It works best for small applications that fit within its 10 GB, 1,410 MB memory, and 4-core limits and don’t need SQL Server Agent.
No. Microsoft’s licensing guide says Developer may not be used in a production environment. That includes any environment that end users rely on, that connects to a production database, or that supports production backup or disaster recovery.
No. Microsoft’s editions table lists SQL Server Agent for Enterprise, Standard, and Web, but not for Express. Without it, scheduled jobs such as automatic backups have to be set up another way.
Move to Standard when a database approaches 10 GB, when the instance needs more than 1,410 MB of buffer pool memory or 4 cores, or when you need SQL Server Agent, transparent data encryption, encrypted or compressed backups, or failover options.
Either. Microsoft offers Standard under Server + CAL, with one server license plus a SQL Server CAL for each user or device, or Per Core, with all cores licensed and no CALs needed.
Questions about SQL Server?
Not sure whether Express will hold up, or which way to license Standard? Tell us about your database and who uses it, and we’ll help you choose.
- Business or volume orders: request a quote.
- Questions or help with an order: email support@solveditservices.com (fastest), or call (447) 223-5297.
- More answers are on our FAQ page.