Microsoft confirms end of extended support for SQL Server 2005

If your company continues to use and support SQL Server 2005 then you need to be aware that the march is in the final stages and 12 April 2016 is a date you need to mark on your calendars.

Richard Hay, Senior Content Producer

April 13, 2015

2 Min Read
Microsoft confirms end of extended support for SQL Server 2005

Lifecycle Management is a normal evolution in an IT professional’s existence. The day comes when every piece of software must be upgraded as technologies change and better solutions become available.

If your company continues to use and support SQL Server 2005 then you need to be aware that the march is in the final stages and 12 April 2016 is a date you need to mark on your calendars.

According to a blog post from T.K. Rengarajan, the Corporate Vice President for Data Platforms at Microsoft, all versions of SQL Server 2005 will reach the end of extended support just one year from now.

A year sounds like plenty of time to plan your migration, but, depending on the type of application, the migration destination, the scale of the move and resources allocated, migrations can take several months. In addition to SQL Server 2005, you may have heard that support for Windows Server 2003 is ending soon. As you plan your SQL Server migration, you should also plan your infrastructure migration to get the most out of our modern platform. Planning now will ensure that you are able to make the move in time and Microsoft is here to help you in that process.

Microsoft is not just going to tell there an expiration date for support and leave you hanging though. They are also providing several resources to help you get started in planning this close out of SQL Server 2005.

Using the moniker of Discover, Target and Upgrade they break things down in three elements and point you towards tools for each piece:

- Discover: Determine which applications are running on SQL Server 2005 and make the case for an upgrade. Assess your current IT infrastructure with the Microsoft Assessment and Planning Toolkit.

- Target: Choose a migration on destination for each application whether on-premises, virtualized or in the cloud. Get a free trial of SQL Server 2014 and Microsoft Azure.

- Upgrade: Plan your upgrade, whether you do it yourself or collaborate with a partner. Upgrade yourself with the SQL Server 2014 upgrade technical guide or Azure SQL Database Migration Wizard or Find a partner to support your upgrade.

For more information and to read about other Microsoft customers who have made the move to SQL Server 2014 be sure to visit the full blog post.

Read more about:

Microsoft

About the Author(s)

Richard Hay

Senior Content Producer, IT Pro Today (Informa Tech)

I served for 29 plus years in the U.S. Navy and retired as a Master Chief Petty Officer in November 2011. My work background in the Navy was telecommunications related so my hobby of computers fit well with what I did for the Navy. I consider myself a tech geek and enjoy most things in that arena.

My first website – AnotherWin95.com – came online in 1995. Back then I used GeoCities Web Hosting for it and WindowsObserver.com is the result of the work I have done on that site since 1995.

In January 2010 my community contributions were recognized by Microsoft when I received my first Most Valuable Professional (MVP) Award for the Windows Operating System. Since then I have been renewed as a Microsoft MVP each subsequent year since that initial award. I am also a member of the inaugural group of Windows Insider MVPs which began in 2016.

I previously hosted the Observed Tech PODCAST for 10 years and 317 episodes and now host a new podcast called Faith, Tech, and Space. 

I began contributing to Penton Technology websites in January 2015 and in April 2017 I was hired as the Senior Content Producer for Penton Technology which is now Informa Tech. In that role, I contribute to ITPro Today and cover operating systems, enterprise technology, and productivity.

https://twitter.com/winobs

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like