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 Oracle error message is very common for database administrators. Learn how to diagnose & resolve this common issue here today.

Vijay Muthu | February 4, 2021

Data Types: The Importance of Choosing the Correct Data Type

Most DBAs have struggled with the pros and cons of choosing one data type over another. This blog post discusses different situations.

Craig Mullins | October 11, 2017

How to Recover a Table from an Oracle 12c RMAN Backup

Our database experts explain how to recover and restore a table from an Oracle 12c RMAN Backup with this step-by-step blog. Read more.

Megan Elphingstone | February 2, 2017

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.