All posts
Legacy Modernization

SQL Server 2016 Has Ended and 2017 Ends October 2027: Upgrade, Move to RDS, or Leave for PostgreSQL

By

October 25, 2026

8 min read

SQL Server 2016 reached end of support on July 14, 2026; SQL Server 2017 follows on October 12, 2027, and SQL Server 2014's last ESUs end in July 2027. The three realistic paths on AWS (a newer SQL Server on EC2 or RDS, Aurora PostgreSQL with Babelfish, or a full conversion with AWS Transform) and what each costs in licences and effort.

SQL Server
Amazon RDS
Aurora PostgreSQL
Babelfish
End of Support
2027

The dates

Version

End of support

Notes

SQL Server 2014

Ended July 2024

Last ESU year ends July 12, 2027

SQL Server 2016

July 14, 2026

ESUs available

SQL Server 2017

October 12, 2027

SQL Server 2019

January 2030

Mainstream support ended February 28, 2025

SQL Server 2022 and 2025

Current

Want a second opinion on this for your system?

Book a free 30-minute call. You'll leave knowing what we'd do first and roughly what it costs, whether or not you hire us.

Three paths

Newer SQL Server

Aurora PostgreSQL with Babelfish

Convert to PostgreSQL

What changes

The version

The engine; Babelfish accepts T-SQL and the SQL Server wire protocol

Engine, schema, stored procedures and application data access

Application changes

Usually none

Few, for supported T-SQL; unsupported features need rewrites

Significant

Licence cost

SQL Server licences remain (Enterprise is the expensive one)

None

None

Tooling

Backup and restore, Database Migration Service

Babelfish Compass assessment, DMS

AWS Transform, DMS Schema Conversion

Best for

Vendor applications that require SQL Server; heavy use of SQL Server-only features

In-house apps with moderate T-SQL

Apps being modernized anyway

Where to run a newer SQL Server

  • RDS for SQL Server, License Included: AWS patches, backs up and fails over; the licence is in the hourly price. The default for most workloads.

  • EC2 with License Included: for features or configurations RDS does not offer, at the cost of running it yourself.

  • BYOL with License Mobility: needs active Software Assurance; without it, Microsoft's 2019 rules push you to dedicated hosts and older licence versions.

  • Check edition. Many databases on Enterprise only use Standard features. Downgrading edition during an upgrade is often the largest saving in the project.

AWS Transform for full-stack Windows

AWS Transform, announced at re:Invent 2025, converts SQL Server schemas (2008 R2 through 2022) to Aurora PostgreSQL, updates the .NET data access code (Entity Framework 6.3 to 6.5 and EF Core), ports the application to modern .NET, and can move ASP.NET Web Forms to Blazor, then deploys to ECS or Linux EC2. AWS charges nothing extra for the transformation itself. It makes conversion far cheaper than it was. It does not make it free: expect to review every stored procedure it converts and to performance-test the result.

hoolco Monthly Review

Once a month: what changed in tech that month and what it means for you, from cloud and AI to security and the tools you build with. Every item links to its source. No sales pitch, unsubscribe in one click.

As of October 25, 2026. Provided as is, for general information, and accurate to the best of our knowledge on the date shown. Not legal, compliance, tax, financial or other professional advice. Prices, limits and vendor services change; check current vendor documentation before relying on anything here. Terms of use.