On July 9, 2019 support ends for SQL Server 2008 and 2008 R2.  On January 14, 2020 support will end for Server 2008 and 2008 R2.

Are you still running any production workloads on these two vulnerable products?  If you are, what’s your plan for migrating to a supported platform prior to end of support?  You do have a plan, don’t you?  You did know this was coming right?

It’s never easy to migrate workloads off a server that isn’t having any issues and it feels like a waste of time.  However, it is important to maintain production data on supported platforms.  Why is it important?  One word—security.  Legacy servers are less secure than their newer counterparts in general and once support ends and security fixes stop, these legacy systems will become increasingly vulnerable to attack.  While security is the most important reason to upgrade, compatibility is also an important consideration.  As time marches on, legacy systems become less and less compatible with more modern ones, making future upgrades more difficult and costlier.  At the same time, it can become more difficult to keep your workload running as vendors update their products that may or may not continue working with/on your legacy systems.

Your three-step plan to move off legacy systems:

  1. Take inventory of anything that is still running on these legacy systems
  2. Evaluate each system to determine if it’s still needed.  If it’s needed, then verify if it will run on a newer SQL/OS version without needing to be upgraded or modified.
  3. Map out the actual migration, including a timeline, which may include an application upgrade prior to or in conjunction with the migration.

You are already having to invest time and money to upgrade is now the right time to consider a move to the cloud?

Most importantly, if you’re not sure reach out to a trusted partner for assistance.