SQL Server 2008 and 2008 left Extended Support on 9th July 2019. In the latest episode of the Coeo Conversations Podcast Sales and Marketing Director James talks about the issue and explores the options available to businesses.
What is End of Support?
All Microsoft products sold as a boxed product solution go through three stages of support:
- Mainstream Support – the product receives bug fixes and security updates
- Extended Support – only security updates are provided
- End of Support – after 10 years the product no longer receives security updates
The biggest risk of running applications on an unsupported platform is security. Those choosing to use an unsupported platform will need to pay to continue to receive security updates, so many companies choose to look at the benefits of modernisation versus staying on their existing platform.
We advise that companies look at the lifecycle of their whole estate, and not just their software. Businesses may find that the point where hardware comes out of support or rent comes up for renewal is a natural opportunity to move to the Cloud.
Application Compatibility, Migration and Upgrading
There are two main types of application used by businesses: vendor supplied applications and applications written in-house.
Vendor Supplied Applications
These applications normally come with some kind of pre-requisite in terms of the type of software that supports them. So, if you want to upgrade your SQL Server and operating system, you'll probably need to upgrade the application too.
Although the migration itself is tends to be fairly seamless, we often see issues involving change management crop up due to new features or user interfaces that are introduced in newer versions of the application.
Applications written in-house
Companies have control over applications that have been created in-house, as well as a greater understanding of their boundaries. For these reasons they often create less friction during a SQL Server upgrade, although some remediation work may need to be done to ensure they're running on the latest framework.
Data Platform Migration and Modernisation
There are two options for remaining on SQL Server 2008:
- Remain on-premises and pay 75% of license fee for Extended Security updates
- Migrate into a Virtual Machine in Azure and receive free Extended Security for three years
For those looking to upgrade, they can choose to:
- Move to Platform as a Service (PaaS)
- Move to Azure with minimal changes
You can find out more about these options and Coeo's four-step technique for modernisation by downloading our SQL Server 2008 whitepaper.
Licensing is a big consideration to make, especially for organisations who are already heavily invested in it. However, you can make significant cost savings, especially if you already have licenses for On-Premises estates.
There are a number of options available when moving to Azure:
- Pay As You Go - the most expensive and the most flexible option
- Azure Hybrid Benefit - available for companies with an Active Enterprise Agreement or Server and Cloud Enrolment Agreement
- Moving Licenses from On-Premises estates
- Reserved Instances - companies can now pay in advance for continuous server usage
Find out more about SQL Server 2008Tweet