SQL Server 2019 vs 2022
Both use the same licensing models — per-core with a four-core minimum, or Server + CAL on Standard edition. SQL Server 2022 adds ledger (blockchain-verified) tables, Azure Synapse Link, managed disaster recovery to Azure and contained availability groups, and is supported until January 2033 versus January 2030 for 2019.
Last reviewed by MSLicenseHub Licensing Desk on 2026-10-22.
SQL Server 2019 vs SQL Server 2022: full comparison
Support lifecycle at a glance
Before you upgrade or buy: checklist
- Confirm which edition you actually run today (Standard, Enterprise, Datacenter, LTSC) — edition, not version, drives most of the price.
- Count the licensing metric this product uses (physical cores, users, devices or seats) on the hosts that will run the new version.
- Check whether active Software Assurance already grants new-version rights before buying new base licences.
- For server products, confirm CALs match or exceed the server version — older CALs never cover a newer server.
- Verify application and hardware vendor support for SQL Server 2022 before scheduling the migration.
- Keep the invoice, agreement number and edition records; activation alone does not prove licence ownership.
Dates are taken from the Microsoft Lifecycle Policy; licensing rules from the Microsoft Product Terms.
Which one should you buy?
Choose SQL Server 2022 if
You want ledger tables for audit-proof records, Azure hybrid analytics, or simply three extra years of support at the same licence cost.
Keep SQL Server 2019 if
It is deployed, certified and you have no Software Assurance — support runs to January 2030, giving you time to plan.
Frequently asked questions
Is the licence cost different between SQL Server 2019 and 2022?
No — the models and core minimums are the same. Cost differences come from edition (Standard vs Enterprise), core count and whether you add Software Assurance.
Can Software Assurance move me from 2019 to 2022?
Yes. Active Software Assurance grants new-version rights, so you can deploy 2022 (or 2025) without buying new base licences.
Can I run SQL Server 2022 on Windows Server 2019?
Yes. SQL Server 2022 supports Windows Server 2016 and later, so an operating-system upgrade is not mandatory — but each product is licensed separately and the older OS reaches end of support sooner.
Do I need to relicense when moving SQL Server into virtual machines?
Per-core licensing applies per virtual machine with a four-core minimum per VM, unless you license all physical cores with Enterprise edition plus Software Assurance for unlimited virtualisation.