Subscribe to my newsletter EDM News
Some Data Conversion Tips
9 March 2010, by , in Data Management, 1 comment

I was recently asked for some guidelines on data conversion, when moving from one database to another. Here are some tips to keep in mind:

  1. Convert only the data you need. And the data you need is probably less than you think. For example, other than open invoices (invoices for which money is still owed), you probably don’t need to convert ANY old invoices. You may want to convert data on what was purchased (e.g., event registration, membership, product, etc.) but the actual details (e.g., payment type, payment date) are probably no longer significant.
  2. Follow the rule of 100-1000. See here for details.
  3. Keep your legacy database (or at least the data from it), but don’t provide immediate access to all users. You will almost certainly need to access your legacy data at some point, but don’t make it too easy for staff to get to it, or they’ll become dependent on it.
  4. Use this opportunity to STOP collecting data you aren’t using. As noted in #1 above, only convert the data you absolutely need. And if no one can make a case for that demographic data you’ve been collecting for years (does anyone really care what school our members went to?), don’t convert it, and stop collecting it.
About author:

1 Comment on "Some Data Conversion Tips"

DBA - 24 November 2010 Reply

Thanks for these tips. I'm compiling similar tips for my website, LegacyDatabase.com. One thing you could add, which I learned the hard way, is to always keep backups of everything (conversion SQL scripts, logins/passwords, ODBC ddls, etc.). I had a mishap once with a complex SQL script that was working 100% but got overwritten somehow and which I had to spend hours trying to reconstruct. Anyway, thanks for the tips!

Leave a Reply

Archives

Sign-up for EDM News

 

 

Testimonials

“Wes was able to come in and offer tangible, relevant advice that made us more productive immediately. I value his understanding of databases but more so, his understanding of how nonprofits work. There was no lost time educating him about how membership organizations are “different.” Wes recommended changes in processes as well as tips and tricks that were easy to implement made an immediate positive impact.”

Mary Pat Paris, Executive Director
International Registration Plan

“We came to Wes because we were very frustrated with our existing AMS and we wanted to improve our capabilities as soon as practicable. Wes very quickly helped us through a process of identifying our needs, identifying potential vendors, and selecting a new system that we’ll be able to move into very quickly. I especially appreciated Wes’s candor about our processes as well as the systems we were looking at. He was a great resource to have in a period of high anxiety for our organization. I would highly recommend Wes for any similar project.”

Jack Chiasson, CMP Executive Director
National Association of Life Brokerage Agencies

“Wes was able to come in and offer tangible, relevant advice that made us more productive immediately. I value his understanding of databases but more so, his understanding of how nonprofits work. There was no lost time educating him about how membership organizations are “different.” Wes recommended changes in processes as well as tips and tricks that were easy to implement made an immediate positive impact.”

Mary Pat Paris, Executive Director
International Registration Plan

Mary Pat Paris
International Registration Plan

“This is the second database implementation we’ve done since I have been at Western Arts Alliance (WAA). The first I did on my own. This time we engaged Wes Trochlil as our database planning consultant. Let me tell you, this process is a whole lot easier having Wes on your team! For a small association like WAA, it’s tempting for board and EDs to question the justification and expense of a database planning consultant. But it’s the small associations that need Effective Database Management the most. Wes strengthened our planning process, clarified our needs requirements, helped us steer around solutions that couldn’t meet our objectives, and saved us money in the long haul.”

Tim Wilson, Executive Director
Western Arts Alliance

Tim Wilson
Western Arts Alliance
%d bloggers like this: