Data migration plan: 6 steps so nothing goes missing
A 60-second cartoon guide to planning a data migration: cleansing, data mapping, a trial run, reconciliation and a rollback plan, so nothing gets lost.
1:05 Transcript below
Chapters
Moving data from an old system to a new one goes wrong in the same few places every time. This short film walks through the six steps of a data migration plan using a filing cabinet, a jammed drawer and a hungry hoover.
For the full version, read our guide on how to plan a data migration, or see how we handle data migration for clients.
Transcript
If you tip the old filing cabinet into the new one, you've migrated.
But the junk comes too. Duplicates, half-filled records, the same customer three times over.
So you clean it in the old cabinet first. This is called data cleansing.
But the new drawers are labelled differently, and the surnames end up under postcodes.
So before anything moves, you write down where every field goes. That's a data map.
But on moving night a drawer jams, and the hoover eats whatever falls out.
So you move one drawer first and check it. That's a trial run.
But how do you know nothing went missing?
So you count both sides. The same number of files out of the old one as into the new one. That's reconciliation.
But a week later the new cabinet breaks, and the old one has already gone to the tip.
So you keep the old one, locked, until the new one has proved itself. That's a rollback plan.
Congratulations, you've built a data migration plan.
Then the hoover eats the key.
More videos
-
0:59 How to become a self-employed sales agent Firing business cards down the high street doesn't make you a sales agent. Here's what does: an agent agreement, a price list, custom quotes, payment links and commission tracking.
-
1:01 How to plan a legacy system replacement Throwing your old screen into the sun doesn't replace your legacy system. Here's what does: audit, requirements, data migration, parallel running and change management.
-
1:45 Digital Royalty in under two minutes What Digital Royalty does, in the order we do it: consulting first, then AI agents, automation, dashboards and portals, websites, and mobile and desktop apps, and how we stay with you as technology changes.