Aaron Russo - Senior Manager for Tech Sales Data Center
Aaron Russo
Senior Manager for Tech Sales Data Center
Jeff Stork - Software Delivery Practice Manager
Jeff Stork
Senior Service Manager
Lane Shelton - Vice President of Software Business Development
Lane Shelton
Vice President of Software Business Development
Tony Dancona - Vice President of VMware EUC
Tony Dancona
VP VMware EUC, Solutions and Services
»See All Authors
Lane Shelton - Vice President of Software Business Development

Life After "SQL-mageddon"

Prepare for Your Migration in Four Steps


With the official end of life looming (RIP, April 12, 2016) for the up to 2 million-plus servers running some form of Microsoft’s popular relational database management system, SQL Server 2005, putting in place a migration plan is not optional—it’s a must. For most, staying with Microsoft represents the least painful alternative, although this is not without its challenges. In addition to the current successor, SQL Server 2014, other options include SQL Server 2012, the eventually-to-be-released SQL Server 2016 or Azure SQL Database (cloud). Read on for the four steps to a successful SQL migration that should be top of mind.

Microsoft SQL Server


The first step is to discover which applications and workloads are running on Windows Server 2005 today. You also need to consider if a server refresh is also in order.


The next step is to assess your infrastructure and categorize applications and workloads by type, importance, and degree of complexity. Depending upon which SQL path you choose, have your migration team take the appropriate upgrade course to accelerate certifications in the skills required to maintain the replacement DBMS, i.e. Upgrading Skills to Windows Server 2012 Jump Start or Azure SQL.

You should also consider architectural options for the migration. This is an opportunity to determine if database or server consolidations are in order, which can lead to reductions in operations and licensing expenses.


Prior to taking the third step, you should test drive your replacement to familiarize yourself with its capabilities. Once you're comfortable with it, target a migration destination for each application and workload upon migration.


The fourth and final step is to officially migrate from Windows Server 2005, either building your migration plan internally or together with a partner.

Moving to a modern infrastructure and databases “is not an insignificant task,” notes my colleague Jonathan Clark, a Product Line Manager for Microsoft at Connection Fortunately, there are a variety of useful evaluation, planning resources and migration toolkits available from Microsoft, i.e. the Microsoft SQL Server 2005 upgrade website, SQL Server 2012 and SQL Server 2016.

For more than 30 years, the Connection family of companies has been trusted to provide and transform technology into complete solutions. For more information, drop us a line.