Do you really need all that historical data?
A question I'll often get from my clients as they're making the transition from one AMS to another is "How much historical data do we need to convert?"
My preferred answer is always "None." The easiest data conversions are those with the least amount of data.
But the more accurate answer is another question: "What will you actually DO with that historical data, if it's converted to your new system?" In my experience, the overwhelming majority of data is never used beyond its original transaction. That suggests that most historical data probably doesn't need to be converted.
Yes, there are some significant exceptions, e.g., certification data. But most historical data probably doesn't need to be converted. Just ask yourself: "If I have that data in the new system, how will I use it?" If you have to think about that before you answer, you probably don't need to convert that data.
Wes's Wednesday Wisdom Archives
Data doesn’t need to be perfect to be useful
Data doesn’t need to be perfect to be useful “Your data doesn’t have to be […]
Don’t just clean data, clean reports and queries
Don’t just clean data, clean reports and queries One of the reasons I exhort my […]
Don’t forget, your staff have day jobs…
Don’t forget, your staff have day jobs… The vast majority of my work is finite […]
Beware the automated “How did we do?” trap!
Beware the automated “How did we do?” trap! One of the downsides of technology is […]
Hindsight is 20/20
Hindsight is 20/20 I’m currently working with a client that is moving from their legacy […]
Cheaper now; costlier later.
Cheaper now; costlier later. Most of my clients are very cost-conscious, understandably. After all, who […]
The unified shopping cart: Dreams vs. reality
The unified shopping cart: Dreams vs. reality One of the more common requests I hear […]
Don’t forget to celebrate!
Don’t forget to celebrate! Truth be told, I’m not a big celebrator. (Maybe it’s because […]
Three thoughts on duplicate records
Three thoughts on duplicate records Duplicate records are a reality in any database of any size, […]
Please don’t do this…
Please don’t do this… I’ve noticed a trend among online retailers that I want to […]