Is data migration like moving house?

Couch too bigWould you move into a new house without checking that it would fit your furniture?

Many of us had the experience of trying to fit a comfy couch, or a large bed, into a room that is too small for it.

It’s frustrating.

Option 1: Move on to a bigger house.

Option 2: Throw out the offending piece of furniture.

Of course, when the house is already paid for, and the couch is an heirloom, or a favorite piece, neither option 1 nor option 2 appeal.

So it makes a lot of sense to plan ahead.

Will your precious pieces of furniture fit into the new location? Or should you rather find somewhere else?

Migrating data is a lot like moving furniture

Often, in business, we outgrow one system and need to replace it with another.

A new system may provide better performance, handle higher transnational volumes, or offer more sophisticated functionality,

In order to maintain our organisational history we typically need to move existing data – customer, supplier, product and transaction data from the old system into the new system.

Unlike our old couch, data cannot simply be ignored if it does not fit.

Yet, like a large couch, data may not comply with new system constraints or may not map into the new table structures,

In fact, in many instances data issues cause substantial delays and cost over runs.

This is because functional teams typically focus on the new functionality required from the new system, and assume that data will fit as is.

Data profiling critical to successful data migration

Project managers need to understand and manage data risks that may impact their timelines.

Data profiling and discovery allows business to identify data issues early, plan the new system structures to fit, and adapt the data to fit the space.

Unlike our old couch, we can adjust data to make it fit better.

Learn more about data profiling with our online course. offered in partnership with, or call us on 0114854856

This analogy comes from the course, and is used with permission of eLearningCurve


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.