Select Page

SQL Server 2008: Outside Expertise Can Help Your End-of-Support Migration

Author: Mehul Joshi | | April 2, 2019

The saying that “all good things must come to an end” applies to software even more so than most other things. That’s the situation faced by many DBAs this year as Microsoft winds down its extended support for SQL Server 2008.

Running unsupported software is a potential minefield, so any data center still using SQL Server 2008 is faced with the challenge of transferring all the necessary data, applications and services from the old product to something current. It’s a non-trivial project, whether you opt for on-site servers, a cloud-based product, or a hybrid of the two.

Theory and Practice

The more time you spend on planning the more smoothly implementation should run, at least in theory. The difficulty is that major migrations like this one don’t come along very often, so many of the key people on your planning team–regardless of their overall experience–may not have been through the process previously. That’s a forbidding prospect, because “not knowing what you don’t know” can have painful repercussions.

That’s not to imply that the skills to complete the project in-house aren’t there. Still, migrating between platforms is an assignment that’s riddled with potential pitfalls for anyone who doesn’t have extensive experience in this specialized task.

The Studio Analogy

For a useful analogy, consider the 1960s heyday of the studio musician. These “hired guns” were specialists in the narrow field of studio recording. In those days, when recordings were made on analog tape with a limited number of tracks, any error or miscue was costly. Musicians who could work efficiently, be creative under time pressure and reliably get things right were a rare and valued commodity. It was a specialized skillset, honed to a fine edge through constant repetition.

It’s not that bands like the Beach Boys weren’t fine musicians in their own right. They certainly were, and they’d mastered the art of performing onstage to a live crowd. In the studio, though, even the best stage musicians took a back seat to the legendary sidemen of California’s “Wrecking Crew” or “The Swampers” of Alabama’s Muscle Shoals Studios. These seasoned pros knew how to work a studio, and they could lay down tracks faster and more efficiently than the bands themselves.

In much the same way, hiring outside expertise can smooth your migration from SQL Server 2008. A managed services provider like Datavail can draw on the cumulative experience of hundreds of DBAs, with extensive hands-on experience in exactly this kind of project. Bringing in professionals with the skills you need is a simple and pragmatic way to manage the time and resources needed to bring the project to a successful conclusion.

For a more detailed look at planning your upgrade from SQL Server 2008, and how Datavail can help, download our white paper today.

How to Solve the Oracle Error ORA-12154: TNS:could not resolve the connect identifier specified

The “ORA-12154: TNS:could not resolve the connect identifier specified” Oracle error is a commonly seen message for database administrators.

Vijay Muthu | February 4, 2021

Using Nulls in DB2

If a column “value” can be null, it can mean one of two things: the attribute is not applicable for certain occurrences of the entity, or the attribute applies to all entity occurrences, but the information may not always be known.

Craig Mullins | April 6, 2015

Scripting Out SQL Server Logins, Server Role Assignments, and Server Permissions

This blog reviews how you can generate scripts for SQL server logins, role assignments, and server permissions for a smooth migration.

JP Chen | October 1, 2015

Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.


Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.