You should already know that Microsoft SQL Server 2005 has reached its end of life (EOL). After 11 years, it finally ended “extended support” on April 12, 2016. There are a number of options for what you can do now. You can easily upgrade to SQL Server 2012 or 2014 unless you want to consider all options including an open source alternative or moving to Oracle. While most of us will select either the SQL Server 2012 or 2014 editions, we have or will soon do something to resolve this issue.
There are some obvious reasons to act now:
- Modernize: Now is your opportunity to use the SQL Server 2005 EOL as the driver (excuse) you need to modernize your infrastructure. Maybe now is the time to rethink your database infrastructure by reviewing server consolidation options, think about moving to the cloud, reviewing DBaaS options, etc.
- EOL: The price of doing nothing after EOL can be severe, specifically around potential security issues. The lack of security updates and vendor support has implications that can impact your entire network environment affecting services and applications that your company may not be comfortable in accepting high risk because of inaction.
- Performance: One not-so-obvious benefit of migrating immediately is the performance boost possible when moving to a newer version of SQL Server. The recent versions of SQL closely support a modern environment with performance gains, added high availability, improved scalability features, and increased business intelligence capabilities.