Select Page

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

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.

12c Upgrade Bug with SQL Tuning Advisor

This blog post outlines steps to take on Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017
sharepoint ideas

9 Awesome Things You Can Do with SharePoint

This blog post discusses out-of-the-box uses for SharePoint that you can execute in just a few clicks without using any code.

Amol Gharat | May 23, 2017

Recover a Table from an RMAN Backup in an Oracle 12c

This blog post will is to show a table restore for one table in a container database

Megan Elphingstone | February 2, 2017

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.