Articles

SQL Server 2016 is out of support: your three options and what each costs

Microsoft stopped fixing SQL Server 2016 for free on 14 July 2026. You can upgrade, move to Azure or pay for Extended Security Updates. Here's what each one costs, from Microsoft's own price lists.

What changed in July

Extended support for SQL Server 2016 ended on 14 July 2026. Since then, Microsoft only releases security fixes for it to customers who pay for Extended Security Updates (ESUs), and only for problems it rates Critical. ESUs don't include other bug fixes or technical support.

That matters beyond the risk of an unpatched database server. Cyber Essentials, for example, requires all software in scope to be licensed and supported, with critical and high-risk fixes applied within 14 days. An unsupported SQL Server can cost you the certificate.

Not sure which version you're running? Run SELECT @@VERSION; and paste the result into our support checker. Version numbers starting 13.0 are SQL Server 2016.

Upgrade to SQL Server 2022 or 2025

This is the permanent fix. Microsoft supports upgrading in place, but we usually recommend building a new server alongside the old one, restoring your databases onto it, testing, and then switching over. If anything goes wrong on the night, the old server is still there.

What it costs:

  • Licences. If your licences have active Software Assurance, you're already entitled to the latest version, so there's nothing more to buy. If not, Microsoft's US list prices for SQL Server 2025 are $3,945 per two cores for Standard edition and $15,123 per two cores for Enterprise, with at least four cores for each server or virtual machine. You can subscribe instead, at $1,418 (Standard) or $5,434 (Enterprise) per two cores a year, or pay by the hour through Azure Arc at $73 or $274 per core a month. Prices in pounds depend on where you buy.
  • The work. Checking for features that have changed or been removed, testing your applications, moving logins, jobs, linked servers and SSIS packages, and a rehearsed switchover with a way back.
  • The operating system. Windows Server 2016 reaches the end of extended support on 12 January 2027, so if your SQL Server runs on it, plan to move both together.

One tip: after the move, leave each database at compatibility level 130 (SQL Server 2016's level) and turn on Query Store. Once you've captured a baseline, raise the level. If a query then slows down, Query Store shows you which one and lets you force its old plan.

Move to Azure

Azure SQL Managed Instance is the closest match to a SQL Server you run yourself: it keeps SQL Server Agent jobs, cross-database queries and linked servers. Microsoft keeps it on the current database engine, so you won't face another end-of-support date. Azure SQL Database suits single databases with no instance-level features, and SQL Server 2022 or 2025 on an Azure virtual machine is the nearest to what you have now.

What it costs: you pay by the hour for compute and storage, and for the SQL Server licence unless you bring your own licences with Software Assurance (Azure Hybrid Benefit). The bill moves from occasional licence purchases to a monthly running cost, so compare the options over three years, not one.

One route has closed: moving SQL Server 2016 unchanged onto an Azure virtual machine no longer gets you free ESUs. That worked for SQL Server 2014, but Microsoft dropped it for 2016.

Pay for Extended Security Updates

ESUs buy time: Critical security fixes for up to three more years, sold in annual terms.

ESU termCovers
Year 115 July 2026 to 13 July 2027
Year 214 July 2027 to 18 July 2028
Year 319 July 2028 to 17 July 2029

To qualify, you need Standard or Enterprise edition (not Express, Web or Developer) with Service Pack 3 installed. You subscribe by connecting the server to Azure Arc and paying monthly or, if you have Software Assurance, through volume licensing.

What it costs: since 1 April 2026, Microsoft charges the same list price for new ESUs wherever the server runs. Through Azure Arc, Year 1 costs £0.1429 per core per hour for Standard edition and £0.5564 for Enterprise, about £104 and £406 per core a month. You pay for every core, with a minimum of four per server or virtual machine, and nothing for passive failover replicas.

A four-core serverPer monthPer year
Standard edition£417£5,007
Enterprise edition£1,625£19,496

Year 1 Azure prices in pounds, excluding VAT, checked 21 November 2026.

Three catches:

  • Joining late doesn't save anything. If you subscribe now, Microsoft bills you back to 15 July 2026.
  • Later years aren't priced yet. Microsoft hasn't published prices for years two and three, and some commentators expect steep rises, so don't budget for three years at today's rate.
  • Without Software Assurance, it costs more. If your licences don't have Software Assurance or a subscription, Azure Arc only offers ESUs once you switch the server to pay-as-you-go licensing, which carries its own hourly charge.

How that compares

Set against the alternatives, a year of ESUs is poor value. At Microsoft's US prices, a year of ESUs for a four-core Standard server costs $6,658. Buying SQL Server 2025 Standard licences for the same server outright costs $7,890, and subscribing costs $2,836 a year. Enterprise tells the same story: $25,930 for a year of ESUs, against $30,246 to buy or $10,868 a year to subscribe.

Without Software Assurance, add pay-as-you-go licensing: another $3,504 a year for the four-core Standard server, which makes a year of ESUs dearer than buying new licences outright.

The good news: you can cancel at any time without penalty, and the charges stop when you upgrade or move to Azure SQL. That makes ESUs a sensible short bridge while you upgrade, and an expensive long-term plan.

Which one fits?

  • You have Software Assurance: upgrade. The licences are already paid for.
  • Your software supplier hasn't certified a newer version: buy ESUs for now, and press the supplier for a date.
  • You're tired of upgrade deadlines and your applications can run in Azure: look at Managed Instance.
  • Whatever you choose: keep the time on ESUs as short as you can.

Get a plan and a fixed price

Our SQL Server 2016 upgrade assessment gives you an inventory of your servers, compatibility checks, the right target version, a plan and a fixed quote for the work. It costs £950 for one instance, then £350 for each extra instance, excluding VAT.

Sources