5 Common (and Dangerous) Data Migration Mistakes

list2

Do you have a data migration looming in your future? As you no doubt already know, moving data takes careful planning, exceptional management skills, and well-developed data migration techniques. Do you also know how to plan for possible setbacks and keep data safe during the transition? You may find it helpful to know what the different types of data migration are, and which category best suits your needs. Finally, you may want to check out our list of the five commonly missed data migration mistakes, which literally serve as a how-to guide for avoiding these potholes on your road to a smooth migration.

For instance, you may be implementing a more common transition, such as a database or storage migration. If you’re switching applications or going through a business acquisition, you may also be moving data between programs or operating systems.

For businesses with a huge volume of files, documents, links, and sensitive information, this process can seem especially daunting. We all know that doing a proper data migration is a complicated task — one that is often bogged down by various issues: You don’t have all the resources that you would ideally want; you have a strict timeframe in which to get the migration done; or the approvals you need take way too long from “those above”.

Of course, even as you wade through these issues, there can be a whole slew of challenges greeting you as soon as you get started. Knowing this, we’ve created a list of the five commonly missed mistakes that usually happen because IT staff are so mired down in handling all the complex details of an important data migration.

By keeping these five mistakes in mind, and watching for them while doing your data migration, you can save yourself a lot of time and frustration — and your company lots of money, which just could lead to them giving some of that saved dough to you, in the form of a raise. (Just sayin’.)

Mistake #1: Trusting That Your Backup Will Be There for You

“I have backups! I have so many backups! We always back-up before we change anything around here!”

We don’t doubt that you back up your data. The problem is that many (too many) IT professionals trust back-ups that turn out to be unreliable or problematic — and they didn’t realize it until it was too late. Cue the hypothetical thought bubble: Do you test those backups?

When was the last time you fully tested your backup system? When was the last time you did a test deployment of your back-up in exactly the same manner as you would have to do it, should you actually lose some data?

Here’s where the mistake hides, like many, in plain sight. Many times, during the crunch of time of a data migration, people are quick to back up, and keep moving. Many times, people have to refer back to those backups, at least to recover some part of their data. Many times the recovery mission fails, and only then do they realize that something was wrong with either the back-up itself or with the recovery system.

Make a copy of your data before migrating it. You want to be able to see everything as it was originally, on its original system, so that you can spot any corruption or anything that looks out of place.

Make sure that you change as little as possible between the “back-up” phase, and the actual migration phase, so that you don’t lose any changes that you might make before the migration.

Oh, yeah, and test your back-up. Run an actual recovery and see what happens.

Mistake #2: Getting Started Without a Solid Strategy

Planning is everything in data migration. It will help you prepare for possible issues along the way, and it can save you boatloads of time and money. Without a solid strategy or outline of the steps you’ll be taking, the migration process could be prone to data losses, security issues, and more.

So what are the steps in a data migration? They can vary slightly depending on your individual needs, but the following are the most basic steps involved in the task. To conduct a successful migration, you need to:

  • Develop a detailed strategy
  • Analyze the data
  • Profile and organize the data
  • Test the data for quality and accuracy
  • Execute migration

By following these steps, you’ll be able to account for every piece of data and its validity before initiating the move. You’re free to make adjustments, operate within this framework, and enlist data migration tools to meet your goals. Just remember to start with a full strategy — the glue that will hold everything together. Even if you’re tempted to let some of the details slide, take our advice and outline them anyway. You’ll be glad you did later.

Mistake #3: Leaving Home Without Roadmap

16759820090_20f5b75870-300x200

Look, you wouldn’t leave your house and try to fumble your way to some place you have never ever been before, without your GPS. Right?

Okay, so why would you start a migration without a detailed report on all your files — where they are and what is connected to what? Knowing where your files are, what their purpose is, and what type of migration you’re doing will make the whole process much easier. It will leave less room for error too.

For additional safety, consider printing a copy of it (yes, on this old-timey stuff called “paper”) and keep it nearby to refer back to. This means that you have something external and physical that maps out your file structure before the migration, so you have something to look back at during the migration itself. Then, if you get lost, you don’t have to stop for directions. (You may still need to make a restroom stop, though.)

A very simple way to do this, for Windows users, is to, of course, generate a report using CommandPrompt. However, this is a very simplistic program that just gives a “broad-strokes” view of your file structures.

Overall, find the tool that works best for you to generate a comprehensive view of your files, including all the links contained within them. (Hint: www.linkreporter.com)

Mistake #4: Lack of Hardware, Software, and/or Network Preparation

“Huh? We have a lot of this stuff (particularly hardware) around here!”

Yes, but you are doing a data migration now. The rules change a bit. Consider the following.

Hardware:

4244913032_f3f7ee8a5c-225x300Make sure that you have the allotted resources for your migration. When you’re doing a migration, you’re usually moving from an outdated or smaller resource to a larger one. Nonetheless, a good “rule of thumb” is to have at least 20% more capacity than what you think you will need.

Secondly, be sure that the hardware you’re migrating to has been tested and passed a benchmark test. Make sure that you’ve thoroughly tested it before the migration, so that you don’t finish up your migration, pat yourself on the back, and then have something break five minutes later.

Software:

During the migration itself, be doubly sure that you’ve shut down any processes or applications on the software you’re using. Having other processes running in the background while you’re trying to do a migration can cause interruptions or complications in your migration.

Tip: If you’re using a Windows machine, check back periodically to be sure no pesky automatic program has started itself up while you weren’t looking. Yeah, these have been known to cause problems surreptitiously. (That means they’re sneaky.) You could spend many hours trying to figure out some weird phenomena, not realizing the source of the problem is something running that you didn’t notice.

Network:

Last, but not least, you want to be absolutely sure you’re working with an open pipe. Make sure your firewall settings aren’t choking you from doing what you need to but aren’t leaving you vulnerable either.

Also, if you’re going to have users on your network while you’re doing your migration, you want to be sure to throttle your own use, so that you’re not slowing down your users.

If you know you’re going to have users on at the time of your migration, plan for it. You can’t kick them out and lock the door (tempting as that may be), so you’ll have to be sure you’re allocating the proper amounts of bandwidth for both you and them, so as to not slow down any work for either of you.

Mistake #5: Not Having a Rollback Plan

Developing a rollback plan is one of the best data migration techniques and can help you save time and energy after the move. You may run into a few challenges while relocating data sets. Right now, you might be thinking you can simply go back and fix everything later. While that’s usually true, it can be a messy and inefficient way to work.

That’s why you need a rollback plan. Rather than waiting until after you’ve moved all the data to address issues, you’ll develop backups and a rollback plan to apply fixes along the way. For instance, one way to implement a rollback plan is to set checkpoints at specific stages of the migration so that you can run assessments on the data. If any transitions need to be rolled back, you can make the backups and deployments necessary to move forward.

Not having a rollback plan will add extra work to your schedule and cause otherwise preventable disruptions after deployment. By adding one to your checklist, you can make sure you’re equipped to address issues right away and create a better final result.

Summary

Some these points might seem obvious, in hindsight. Yet these are the things that have bitten many an IT pro in the you-know-what. You should pay extra attention to these areas when planning a data migration, no matter how big or small. Making sure you plan for all these things will keep you vigilant, and help make the other aspects of your migration run smoothly (“smoothly” being a relative term).

If you’re interested in learning more about data migration tools and techniques that can help you move in the right direction, contact us today.

Ed Clark | Chief Operating Officer | Helping IT, CIO’s and Information Governance avoid losing data due to migrations or errors | LinkMail@LinkTek.com

photo credit: All you need is the plan, the road map, and the courage to press on to your destination. Earl Nightingale via photopin (license)

photo credit: New servers at work via photopin (license)

Try Now!

Related Posts

SharePoint on premise vs online

Risks and Rewards: Migrating from SharePoint On-Premise to SharePoint Online

Mar 4, 2024

There’s no stopping the tidal wave of migration from SharePoint On-Premise to SharePoint Online. Here’s why, and what to expect

Read More
hardware upgrade hardware refresh

Hardware Upgrade? Hardware Refresh? A Guide to 5 Best Practices & 1 Major Misconception You Need to Know

Feb 23, 2024

The difference between a hardware upgrade and a hardware refresh — they’re not the same — plus 5 tips for best practices.

Read More
joseph popp

Malice, Money, Monkeys and a Madman: The Origin of Ransomware

Feb 19, 2024

IT Tips & Tricks Malice, Money, Monkeys and a Madman: The Origin of Ransomware Published 19 February 2024 Share on Facebook Share on Twitter Share…

Read More
box migration tool

Release of New Version of Link-Fixing Software Offers Support for Migrations To or From Box.com

Feb 25, 2022

Data migrations can be tricky. Migrating to or from Box is no different. Get some help.

Read More
Software Update

Latest Release of LinkFixer Advancedâ„¢ Streamlines Cloud Data Migrations

Jan 27, 2020

Migrating to the cloud? Link-fixing software helps prevent post-migration data-loss. Chat with us about options, including a free webinar.

Read More
Computer Server

Newest Release of Automatic Link Fixing Software Simplifies the Process of Protecting Links When Moving to SharePoint On-Premise or Online

Oct 2, 2018

Whether on-premises or online, a migration to SharePoint could result in data loss without the best tool for the job. Chat with us about your options.

Read More