SQL Server 2012 will reach end-of-life by July 2022. What next?

By James
4th April 2022

SQL Server is undergoing some significant changes and among these, all editions of SQL Server 2012 will reach end-of-life (i.e. end of Microsoft support) from 12th July 2022.

To help you through the decision-making process for your SQL Server 2012 database, our SQL experts have responded to the main questions you might ask yourself.

Does It Matter?

Yes. After 12th July 2022, Microsoft will no longer release hotfixes, cumulative updates or service packs and will not be able to provide support for any security vulnerabilities or bugs that are identified in your SQL Server 2012 instance.  This presents a risk to your organisation’s data should you encounter any issues.

Running end-of-life platforms can also affect your organisation’s compliance eligibility (e.g. CyberEssentials, PCI, SOC 2, ISO27001:2013).

 

What Can I Do?

WellData recommends that you upgrade or migrate your SQL Server 2012 instances to a supported version; this could be either on-prem, cloud Infrastructure-as-a-Service (IaaS) or Platform-as-a-Service (PaaS).

The latest general availability release is SQL Server 2019, however SQL Server 2022 is on its way this year.

 

Can I Stay on SQL Server 2012?

Yes.  In some cases, often due to legacy application compatibility, it is not possible to upgrade or migrate.  SQL Server 2012 will continue operating as normal, but your organisation would need to accept and document the risks associated.

If you have to stay on SQL Server 2012 (or SQL Server 2008 R2) then Microsoft does offer Extended Security Updates for these platforms until October 2023.  This is available for free if your SQL Server 2012 instance is migrated into an Azure virtual machine.  Otherwise, your organisation would need both Software Assurance and an Enterprise Agreement in order to purchase the Extended Security Updates.

WellData provides managed service for any version of SQL Server, this would ensure your legacy instances are kept as secure, performant and reliable as possible but does not mitigate against the risks associated due to the ending of Microsoft support.

 

What next?

There are a number of proactive steps you can take to prepare for the upgrade:

 

If you are unsure about carrying out any of these actions then please contact WellData today and we will be happy to help guide you through the entire process.

 

Get in touch

Share

<< Back to resources

Join Our Newsletter

Contact Email  *
First Name 
Last Name 
*Required Fields
I agree to the  Privacy Policy and  Terms of Use 

Here's what other people think

Google Rating
5.0
High standard, professional service. I've worked with Welldata for a number of years and always found their DBA's to be knowledgeable and proactive. Throw any question at them and it will be resolved, it gives real peace of mind knowing you have a partner you can rely on from emergencies to general questions. They also like a challenge and we do throw a few curved balls at them.read more
Paul Miller
Paul Miller
12:34 27 Aug 21
The support I receive from Well Data is extremely responsive. Richard Parsons is my contact and keeps me informed daily on the health of our SQL Databases. Whenever I ask for assistance from Well Data it is quick and professional.read more
Kay Riley
Kay Riley
13:41 19 Aug 21
Really know their stuff and their response times are very good. They provide us with a vital service.
Andy Cole
Andy Cole
13:36 19 Aug 21
The guys at WellData really know their stuff. We wanted a quick route to doing something complex and they sorted it for us very quickly and to a high standard. Very professional, no ego, just excellent and to the point consultancy.read more
Steve Goacher
Steve Goacher
11:31 14 Nov 19
I have worked with the WellData team for many years now and they have always delivered.I would highly recommend them to any business looking for best-value outsourced Expert DBA’s.Being able to offer a rolling contract on the basis that if they don’t deliver you can leave shows their confidence and commitment.Their professionalism and knowledge is second to none.read more
Petro Bartoszyk
Petro Bartoszyk
08:51 18 Oct 19
A very dedicated team of extremely professional and knowledgeable experts
Giulia Iannucci
Giulia Iannucci
14:08 16 Nov 18
We use Welldata for SQL support and are very happy with their service.
David Sadler
David Sadler
09:40 15 Nov 18
Really know their stuff and their response times are very good.
Andy Cole
Andy Cole
11:45 06 Nov 18
Our partnership with WellData has enabled us to resolve critical database problems. Their attitude and service makes them a natural extension to our own technology team, which extends our capability in a critical area of our business.read more
Steve Fenton
Steve Fenton
10:56 05 Nov 18
Having worked with the team at Welldata for approaching 17 years, my company and I have always found them professional, reliable and generally a great firm to work with.read more
John Lynes
John Lynes
14:00 04 Oct 17
WellData provide an excellent level of support and their team are very knowledgeable and always go the extra mile. I would wholeheartedly recommend them.read more
Stefan Parrott
Stefan Parrott
13:12 19 Sep 17