SQL Server 2025 vs 2022: New Features and Upgrade Path
SQL Server 2025 vs 2022 comes down to three things: 2025 adds built-in AI and vector search, native JSON and regular expressions; it raises Standard edition limits to 32 cores and 256 GB of memory (from 24 cores and 128 GB); and it is supported for longer. SQL Server 2022 is still fully supported and remains a sound choice for stable workloads.
Key takeaways
- SQL Server 2025 became generally available on 18 November 2025; mainstream support runs to January 2031.
- SQL Server 2022 stays in mainstream support until January 2028, so there’s no emergency to move.
- Standard edition gets the biggest practical win: 32 cores, 256 GB buffer pool and Resource Governor.
- Express grows to 50 GB per database; Web edition is discontinued in 2025.
- Direct upgrades to 2025 are supported from SQL Server 2014 SP3 and later; test linked servers and replication first because of TLS changes.
In this guide
- SQL Server 2025 vs 2022 at a glance
- What are the main SQL Server 2025 new features?
- Edition and licensing changes in SQL Server 2025
- What breaks or changes when you upgrade?
- How to upgrade SQL Server 2022 to 2025
- Should you upgrade from SQL Server 2022 to 2025?
- Frequently asked questions
- The bottom line
- Useful links
SQL Server 2025 vs 2022 at a glance
The table below compares SQL Server 2025 and SQL Server 2022 on the points that usually decide an upgrade: support dates, Standard and Express limits, AI and developer features, and editions. Figures are from Microsoft’s lifecycle and editions documentation as of autumn 2026.
| Area | SQL Server 2022 (16.x) | SQL Server 2025 (17.x) |
|---|---|---|
| General availability | 16 November 2022 | 18 November 2025 |
| Mainstream support ends | January 2028 | January 2031 |
| Extended support ends | January 2033 | January 2036 |
| Standard: max compute | Lesser of 4 sockets or 24 cores | Lesser of 4 sockets or 32 cores |
| Standard: buffer pool memory | 128 GB | 256 GB |
| Standard: Resource Governor | Enterprise only | Included |
| Express: max database size | 10 GB | 50 GB |
| Vector data type and vector search | No | Yes (vector index in preview) |
| Regular expression functions | No | Yes (REGEXP_LIKE, REGEXP_REPLACE and others) |
| Native JSON data type | No (JSON stored as text) | Yes |
| Optimized locking | No | Yes |
| Free development editions | Developer (Enterprise features) | Enterprise Developer and Standard Developer |
| Web edition | Available | Discontinued |
What are the main SQL Server 2025 new features?
The headline SQL Server 2025 new features are a native vector data type with vector search for AI workloads, T-SQL functions to call AI models and generate embeddings, regular expressions, a native binary JSON type, optimized locking to reduce blocking, and near real-time change event streaming.
Vector data type and AI integration
SQL Server 2025 can store embeddings in a dedicated vector column, held in an optimised binary format but exposed as JSON arrays. Functions such as VECTOR_DISTANCE handle similarity search, and CREATE VECTOR INDEX (DiskANN-based, still in preview at the time of writing) speeds up nearest-neighbour queries.
You can also register external models with CREATE EXTERNAL MODEL and generate embeddings in T-SQL using AI_GENERATE_EMBEDDINGS and AI_GENERATE_CHUNKS. In practice, that means retrieval-augmented generation (RAG) can run against data where it already lives, without copying it to a separate vector database.
Developer features: regex, JSON and REST
- Regular expressions:
REGEXP_LIKE,REGEXP_REPLACE,REGEXP_SUBSTR,REGEXP_COUNTand more replace awkwardLIKEand CLR workarounds. - Native JSON: JSON is stored in a binary format, with new aggregates
JSON_OBJECTAGGandJSON_ARRAYAGG. - REST calls from T-SQL:
sp_invoke_external_rest_endpointlets the database call REST or GraphQL endpoints, including Azure OpenAI.
Engine and availability improvements
Optimized locking reduces blocking, lock memory and lock escalation, which is a practical win for busy OLTP systems. Change event streaming (preview) publishes row changes to Azure Event Hubs or Fabric Eventstream, and Fabric mirroring replicates on-premises data into Microsoft Fabric for analytics.
Microsoft’s What’s new in SQL Server 2025 page lists the full set, including which features still need the PREVIEW_FEATURES database setting.

Edition and licensing changes in SQL Server 2025
SQL Server 2025 keeps Enterprise, Standard and Express, drops Web edition, and adds a free Standard Developer edition alongside Enterprise Developer. Standard rises to 32 cores and 256 GB, gains Resource Governor, and Express now allows 50 GB databases and absorbs the old Express with Advanced Services features.
| Edition | Who it’s for | Key 2025 limits |
|---|---|---|
| Enterprise | Large, mission-critical estates | Operating system maximum compute and memory |
| Standard | Small and mid-sized business workloads | 32 cores, 256 GB buffer pool, 524 PB database |
| Express | Free, small apps and learning | 1 socket or 4 cores, 1,410 MB buffer pool, 50 GB database |
| Standard Developer | Free dev/test matching Standard | Same as Standard; not for production |
| Enterprise Developer | Free dev/test matching Enterprise | Same as Enterprise; not for production |
The Standard changes matter most for smaller organisations. Many 2022 servers were capped at 128 GB of buffer pool even on hosts with far more memory, and 2025 doubles that without moving to Enterprise pricing. Our SQL Server editions comparison explains when Enterprise is still worth it.
Licensing models stay the same in principle: per core, or Server + CAL for Standard. Your SQL Server licence is separate from the Windows Server licence underneath it, which our Windows Server 2025 licensing guide covers.
What breaks or changes when you upgrade?
The main upgrade risks in SQL Server 2025 are stricter encryption defaults (TDS 8.0 and TLS 1.3 support), which can break older linked servers, replication and log shipping connections, plus removed features: Data Quality Services, Master Data Services, Synapse Link and Web edition. Check these before any production upgrade.
- Encryption and certificates: Microsoft lists breaking changes for linked servers, replication, log shipping and PolyBase. Make sure servers present trusted certificates, or connections that worked on 2022 may fail.
- Discontinued features: Data Quality Services (DQS), Master Data Services (MDS), Azure Synapse Link (replaced by Fabric mirroring) and Purview access policies.
- Deprecated: hot add CPU, and lightweight pooling / fibre mode.
- Platform: 64-bit only, .NET Framework 4.7.2 required, and Enterprise edition isn’t supported on Windows 10 or 11 (Standard and Express are).
A pattern we see in support tickets: the database upgrade itself goes smoothly, and the problem surfaces days later in a nightly job using a linked server. Test every scheduled job and external connection in a staging copy first.
How to upgrade SQL Server 2022 to 2025
You can upgrade SQL Server 2022 to 2025 in place by running SQL Server 2025 Setup and choosing Upgrade from a previous version, or migrate to a new server with backup/restore or a distributed availability group. Direct upgrades are supported from SQL Server 2014 SP3, 2016 SP3, 2017, 2019 and 2022.
- Check prerequisites: Windows Server 2019, 2022 or 2025 (or Windows 10/11 for Standard and Express), .NET Framework 4.7.2, at least 6 GB free on the system drive, and no pending reboot.
- Run a test upgrade on a restored copy using the free Standard Developer or Enterprise Developer edition.
- Back up everything: user databases,
master,msdb, and SQL Agent jobs, logins and certificates. - Confirm SQL Server Agent uses Windows authentication and its service account is in the
sysadminrole, as Microsoft’s checklist requires. - Run Setup and choose Installation > Upgrade from a previous version of SQL Server. Enter your SQL Server 2025 product key when prompted.
- Keep compatibility level at 160 (2022) at first, then raise it to 170 once the workload is proven.
- Retest linked servers, replication, backups and application connection strings.
Features can’t be added during an in-place upgrade; run Setup again afterwards to add them. For a clean install on new hardware, our SQL Server 2025 Standard install guide covers download, setup and activation. Microsoft’s supported upgrade paths page lists every edition route.
Planning a SQL Server 2025 upgrade?
A SQL Server 2025 Standard licence gives you the higher 32-core / 256 GB limits and support to 2031. If you’re staying on 2022 for now, SQL Server 2022 Standard remains supported until January 2028. Larger deployments can request a B2B quote.
Should you upgrade from SQL Server 2022 to 2025?
Upgrade to SQL Server 2025 if you need vector search or AI features, have outgrown Standard’s 128 GB or 24-core limits, or are building a new server anyway. Stay on SQL Server 2022 if it runs a stable line-of-business app, relies on linked servers or replication you haven’t tested, or uses removed features such as MDS.
| Your situation | Our suggestion |
|---|---|
| New server or new application | Start on SQL Server 2025 |
| Standard edition hitting memory or core limits | Upgrade to 2025 before considering Enterprise |
| Building RAG or semantic search | 2025, for the vector type and AI functions |
| Stable 2022 server, vendor app not yet certified for 2025 | Stay on 2022 and plan for 2027 |
| Still on 2014, 2016 or 2017 | Go straight to 2025 rather than 2022 |
Check your application vendor’s support statement before upgrading. Many line-of-business apps certify new SQL Server versions months after release, and running an uncertified version can complicate support calls. If you’re moving the operating system too, see Windows Server 2025 Standard vs Datacenter.
Frequently asked questions
When was SQL Server 2025 released?
SQL Server 2025, version 17.x, became generally available on 18 November 2025. According to Microsoft’s lifecycle page, mainstream support runs until January 2031 and extended support until January 2036. SQL Server 2022 was released on 16 November 2022 and stays in mainstream support until January 2028, with extended support to January 2033.
What is the biggest difference between SQL Server 2025 and 2022?
For developers, it’s built-in AI support: a native vector data type, vector search and T-SQL functions for embeddings. For businesses on Standard edition, it’s capacity: SQL Server 2025 Standard supports up to 32 cores and 256 GB of buffer pool memory, compared with 24 cores and 128 GB in SQL Server 2022.
Can I upgrade directly from SQL Server 2022 to 2025?
Yes. SQL Server 2025 Setup supports in-place upgrades from SQL Server 2022, 2019, 2017, 2016 SP3 and 2014 SP3. Back up all databases first, test on a copy using a Developer edition, and check linked servers and replication, because stricter encryption defaults in 2025 can break older connections.
Is SQL Server 2022 still supported?
Yes. SQL Server 2022 is in mainstream support until January 2028 and extended (security-only) support until January 2033. It still receives cumulative updates, so there is no urgent need to upgrade a stable 2022 server. Many organisations plan the move for 2027 once vendors have certified their applications for 2025.
Is SQL Server 2025 Express free, and what are its limits?
Yes, SQL Server 2025 Express is free for production use. It is limited to the lesser of one socket or four cores and about 1.4 GB of buffer pool memory, but the maximum database size rises to 50 GB, up from 10 GB in SQL Server 2022. Express with Advanced Services has been merged into it.
Does SQL Server 2025 run on Windows 11?
SQL Server 2025 Standard and Express editions are supported on Windows 11 and Windows 10, including Pro and Home. Enterprise edition requires Windows Server 2019, 2022 or 2025. All editions need a 64-bit x64 processor, at least 6 GB of free disk space and .NET Framework 4.7.2.
The bottom line
SQL Server 2025 is the better long-term platform, with AI features, higher Standard limits and support to 2031, but SQL Server 2022 isn’t going anywhere before 2028. Test your connections, check vendor support, and when you’re ready, follow our SQL Server 2025 Standard installation guide.
Useful links
| Resource | Why it helps |
|---|---|
| Microsoft: What’s new in SQL Server 2025 | Full feature list and preview status |
| Microsoft: supported upgrades to 2025 | Version and edition upgrade paths |
| SQL Server editions compared | Enterprise vs Standard vs Express |
| SQL Server 2025 Standard install guide | Download, install and activate |
| Windows Server 2025 licensing | Cores and CALs for the host OS |
| Windows Server 2025 Standard vs Datacenter | Choose the right server edition |
| SQL Server 2025 Standard | Licence for the new version |
| SQL Server 2022 Standard | Licence if you’re staying on 2022 |