On July 9th 2019, support for Microsoft SQL Server 2008 and 2008R2 will end. We sat down with our Head of Data Platform, Daniel Thompson, to discuss potential SQL upgrade paths.
It’s important that organisations keep pace with change.
If you are still using SQL Server 2008 or even earlier versions of the platform than its time to upgrade. Delivering exceptional public sector services demands resilient, secure and high-performing databases—so it’s crucial to keep pace with change.
With cyberattacks on the rise and GDPR now in effect, it couldn’t be more critical to avoid unnecessary security and compliance risks by using outdated and unsupported versions of SQL Server.
When planning your upgrade path, you need to consider what’s best for your organisation. Options could include:
1. Upgrading to SQL on premise.
Migrating to the latest version of SQL Server 2017 on premise unleashes many benefits—with enhanced features, functionality, performance and cost-effectiveness.
It also lays the foundation for databases that can support long-term service transformation—enabling the development of new applications that better meet the needs of staff and citizens.
2. Upgrading to SQL on Azure.
The benefits of a SQL Server upgrade go even further in the cloud.
Azure brings greater agility, scalability and cost-effectiveness, while also enabling your databases to exploit advanced cloud capabilities, like data analytics and robotic process automation, something more and more public sector organisations are taking advantage.
You can also take a Software, Platform, or Infrastructure-as-a-Service approach to the cloud, dependent on what’s best for you.
3. Buying yourself more time.
If you’re not ready to change, you can also buy three more years of security updates and time to consider a long-term solution by purchasing a Microsoft Software Assurance or Enterprise Subscription agreement.
Even more cost-effectively, you can migrate your existing SQL Server 2008 installation to Azure, where you’ll receive three more years of security updates, while only incurring compute and infrastructure costs.
What should organisations do now?
Each organisations post SQL 2008 path will depend on a number of factors, your existing infrastructure, budget and cloud approach. With only a few months to go before Microsoft ends standard support for SQL 2008, now’s the time to assess and plan the way ahead.
Combining a deep knowledge of SQL Server with two decades of public sector experience, our expert team can help you identify the best path forward.
As a Microsoft Data Platform Gold partner, you can rely on us to minimise the risk and disruption of a SQL upgrade, enabling a seamless and cost-effective transition to the future.