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. Discover 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. Assess 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. Target 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. Migrate 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 PC Connection, Inc. 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. Related content brandpost Sponsored by Connection Creating a Truly Immersive, Connected Fan Experience By Tim Allen Oct 04, 2017 1 min Consumer Electronics brandpost Sponsored by Connection 6 Reasons to Modernize with Intel® and Microsoft By Dave Olivier Sep 28, 2017 4 mins Enterprise Applications brandpost Sponsored by Connection Simplified Global IT Procurement By Jamal Khan Sep 22, 2017 1 min Technology Industry brandpost Sponsored by Connection Funding Education Technology for Students with Disabilities How technology can support students with disabilitiesrn By Lisa Trisciani Sep 13, 2017 1 min Technology Industry Podcasts Videos Resources Events SUBSCRIBE TO OUR NEWSLETTER From our editors straight to your inbox Get started by entering your email address below. Please enter a valid email address Subscribe