10 Big Data Migration Mistakes - InformationWeek
Data Management // Software Platforms
09:56 AM
Connect Directly
How Cloud Can Streamline Business Workflow
Jul 11, 2017
In order to optimize your utilization of cloud computing, you need to be able to deliver reliable ...Read More>>

10 Big Data Migration Mistakes

Beware these pitfalls and risks when transferring your data to new computer systems or storage formats.

And now for the five big data migration risks:

Risk #1: Employees entrusted with a data-migration project lack industry best-practices experience.
A organization's employees may be very good at what they do, but that doesn't mean they're experts in data management, migration, and governance.

"They are creators and consumers of data, but they're not fully familiar with best practices on tools, processes, services, templates, and accelerators," Singh said.

Risk #2: Your team relies too much on the tools of the job.
This problem is often the result of staff inexperience. A data-migration project often falls in the lap of IT, which may not be properly trained to manage it. A migration tool used improperly can wind up moving bad data. "It's the garbage-in, garbage-out analogy," Singh said.

Your goal, of course, is to transfer data quickly and reliably. What matters is how well you use data-migration tools, and "what accelerators and templates you have that go along with the tools," said Singh.

Risk #3: Cross-object dependencies.
"I can't tell you how many times I've sat in a meeting where (a client) said, 'We just discovered a whole new source of data that we were not even aware needs to be moved,'" Singh said.

Cross-object dependencies often are not discovered until very late in the migration process. A complex project may have 60, 70, or perhaps even 80 different data objects coming in from a hundred or so different applications.

"When we get involved with clients, we look for those missing pieces of data or dependencies," said Singh.

Indeed, cross-object dependencies--and discovering new sources of data late in the process--are major risks that can throw off your migration timeline.

Risk #4: Attempting to go live in one big upload at the end.
This is a recipe for disaster, Singh said, because you're assuming that everything is perfect--that you're going to be able to simply hit a button, and all the data will load flawlessly.

"That's a big risk," he said. "You need a project timeline with multiple, iterative test loads along the way."

Risk #5: Budget overruns due to inadequate scoping or preparation at the start.
This often happens when an organization believes its systems integrator (SI) will take care of these details. Big mistake.

"Most SIs usually don't handle data beyond saying, 'I'll connect the pipes and move the legacy data into a target system,'" Singh said.

"We get called into data-migration projects that are in the realization phase," he said, "and people are saying: 'Look, the data isn't tying together, we're not able to do user testing.'"

This problem, of course, can lead to cost overruns and wrecked timelines.

One of the biggest challenges facing IT today is risk assessment. Risk measurement and impact assessment aren't exact sciences, but there are tools, processes, and principles that can be leveraged to ensure that organizations are well-protected and that senior management is well-informed. In our Measuring Risk: A Security Pro's Guide report, we recommend tools for evaluating security risks and provide some ideas for effectively putting the resulting data into business context. (Free registration required.)

2 of 2
Comment  | 
Print  | 
More Insights
Oldest First  |  Newest First  |  Threaded View
How Enterprises Are Attacking the IT Security Enterprise
How Enterprises Are Attacking the IT Security Enterprise
To learn more about what organizations are doing to tackle attacks and threats we surveyed a group of 300 IT and infosec professionals to find out what their biggest IT security challenges are and what they're doing to defend against today's threats. Download the report to see what they're saying.
Register for InformationWeek Newsletters
White Papers
Current Issue
IT Strategies to Conquer the Cloud
Chances are your organization is adopting cloud computing in one way or another -- or in multiple ways. Understanding the skills you need and how cloud affects IT operations and networking will help you adapt.
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
Join us for a roundup of the top stories on InformationWeek.com for the week of November 6, 2016. We'll be talking with the InformationWeek.com editors and correspondents who brought you the top stories of the week to get the "story behind the story."
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.
Flash Poll