Skip to main content

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

  1. 0:00 Tip it in
  2. 0:10 Data cleansing
  3. 0:20 Data map
  4. 0:31 Trial run
  5. 0:38 Reconciliation
  6. 0:50 Rollback plan

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.