On April 12th, Microsoft will end support for SQL Server 2005, which means there will be no more updates or security patches for the server. Consequently, businesses running the unsupported 2005 version won’t be protected against new threats and may have trouble meeting regulatory compliance requirements.
Potential issues with upgrades such as application compatibility challenges may be a reason why some businesses have held off. However, remaining on SQL Server 2005 may no longer be a valid option versus the security risks. To avoid this Microsoft recommends upgrading to the latest version of the software, SQL Server 2014, or migrating to its cloud-based Azure SQL Database.
Whilst there is an associated cost with any migration, a Microsoft commissioned Forrester report in July 2014 found that upgrade costs could be recouped within a year.
Furthermore, though SQL Server 2005 was at the forefront of relational database management technology when it was released a decade ago, its users risk losing the competitive edge now that modern technology is available. Improvements, new capabilities, and the cloud have all happened since SQL Server 2005 was first introduced. An upgrade to SQL Server 2012 or 2014 offers enhancements to performance, availability, scalability and manageability through features like Always On in SQL Server 2012 and In-Memory OLTP in SQL Server 2014.
Ballard Chalmers experts can help you to overcome challenges to upgrading and select the best option for your business. We know SQL Server inside out and you would be hard-put to find better knowledge and experience of SQL Server in the UK. We invite you to contact us to discuss migration strategies and the options available to you.