Join The NonProfit Times: or Become a member

Subscribe: Print Publication or Newsletter

Stay connected.
Stay informed.

Tears, Hair Loss And Data Migration

By Andy Segedin - March 9, 2016

If your organization is in the midst of migrating its databases to another system, there is a good chance that your office is littered with clumps of hair and tissues. Employees of organizations considering a migration might fear a similar fate.

Leaders in the field shared their successes and hardships during “The Good, the Bad and the Ugly: Things to Consider When Planning a Database Migration” during DMA’s 2016 Washington Nonprofit Conference. The program offered a step-by-step tutorial on what to consider, how to approach and what to prepare for when it comes to migrating organizational data, an oft-draining, complicated process.

A database migration is not something an organization should change for the sake of change, according to Alicia Meulensteen, vice president, direct response and stewardship at ASPCA, headquartered in New York City. Budget and staffing and resource should be considered. Can your existing team handle the extra work? Will outside partners be needed? Necessary timeline and time remaining on an existing contract must also be considered, Meulensteen said and, no, those two factors are not synonymous.

Catherine Ewald, director, revenue database/operations at the International Rescue Committee (IRC) in New York City, added that a system going to sunset is a common reason for migration. When selecting a new system, ability to synchronize with existing CRM and payment-processing software, the need for remote or local servers, ease of use, and, in IRC’s case, ability to handle a variety of international currencies are factors to consider. Meulensteen emphasized stability as another important factor. Could your new provider potentially be bought out by the provider you just moved away from?

Once the why and who are settled, here are some of the tips panelists provided to help ensure a smooth transition:

* Come up with a sample timeline. Migrations, start to finish, typically take between 12 and 18 months to complete, not including an additional year or two for refinements, according to Meulensteen. Do not feel as though you have to force something and do not launch with a half-baked database. ASPCA leaders extended timelines during their recent migration and Ewald, likewise, emphasized the importance of staying flexible and building space for roadblocks into a timeline.

Try to secure a buy-in among staff. The process is seldom easy, but well worth working toward, according to Steve Alexander of Alexander Strategies. Educate staff on the migration and set expectations. Understand and convey during the buy-in process that, while a migration might help facilitate the raising of more money, it far from guarantees it.

* Engage key stakeholders in the process. ASPCA had a group of about 10 employees who helped guide the migration throughout the entire process, according to Meulensteen, including analytics, stewardship and major-gifts staffers. Look at new and existing hires. Will job descriptions change post-launch? Will new positions be needed? Hire necessary future staff as early as possible, Meulensteen recommended. It might seem like you are paying someone for work that isn’t being done yet, but an early hire could lead to better long-term efficiency. Ewald was involved in the mapping and integration process of IRC’s migration. She recommended bringing someone on to tend to the day-to-day necessities of the migration.

* Know that the process doesn’t stop post launch. Ewald recommended coming up with a testing plan for the new system based off of key functions to be used. IRC did not run parallel systems shortly after launch, but recommends checking whether it would be possible to extend existing service long enough for an overlap. Alexander, too, recommended having an overlap.

* Keep the conversation going. Set up a stakeholder group to keep the lines of communication open. Prepare to have a backup if things don’t go well. IRC had to make do with being unable to send out acknowledgements for a month after its migration or report for three months after migration. Consider all possible scenarios.


Sponsored Podcasts

Welcome to the Raise & Engage podcast, a filters-off series for nonprofit professionals hosted by Blackbaud's straight-shooting expert Danielle Johnson Vermenton. During this open-mic session, you’ll hear honest advice to help YOU do more for your cause.

Episode 6: The Power of ‘No’ at Work|| daniellejohnson-76

You have a job description, but on any given day, you're probably doing dozens of things outside the scope of that description. Combine that with the challenge of a fast-paced environment and the shifting priorities of funders, colleagues, and board members and it’s easy to fall short of doing your best. By being mindful of your limitations and capacity—and saying “no” when your plate is full—you can actually do more for your cause. In the sixth installment of the Raise and Engage podcast Danielle Johnson and Robin Anderson discuss the power of saying “no” at work.

Episode 5: Professional Development: Getting Un-Stuck|| daniellejohnson-76

In the most recent episode of Raise + Engage, Danielle is back with Brian Reich from little m media to discuss how nonprofit professionals can stay motivated and energized in their day-to-day roles. Brian shares his experience working with nonprofits and the lessons and tips he's learn from and shared with them over the years, including tips for avoiding a professional rut, creating forward momentum in your career and pushing yourself outside of your comfort zone. If you're considering making a career move or want to ensure you're on the right path, you won't want to miss this inspo-packed episode!

Episode 4: Apps and Hacks to Stay (Mostly) Sane || daniellejohnson-76

Episode 4: Apps and Hacks to Stay (Mostly) Sane, is all about tips, tricks and tools for sanity. Blackbaud’s own interactive product marketer, Julia Lenz, joins host Danielle Johnson to share some high tech. (and no tech.) productivity tips to help nonprofit professionals stay sane in the crazy world of philanthropy.

Tune in to hear:

  • Tips for how to spend the first 30 minutes of your day
  • The benefits of 15 minute meetings
  • Why notebooks are still relevant to a successful organization
  • Ideas for better managing your inbox
  • Why you should take lunch outside the box
  • ...and much more!
Don’t forget to visit the #NoFilterNonprofit Hub afterwards to download our newest tip sheet10 Productivity Hacks for Nonprofits.

Episode 3: Tech. Connection: Solutions, Strategy, and Staff || daniellejohnson-76

Episode 3: Tech. Connection: Solutions, Strategy, and Staff In episode 3 of the Raise + Engage podcast, Danielle Johnson is joined by Chris Geady and William DaSilva, two IT experts in the nonprofit space, to talk technology integration for NPOs: when you need it, when you don’t, and how to do it successfully.

Tune in to hear:

  • When to say NO to integration
  • How to set your strategic plan before even looking at technologies
  • Ways to get your entire team on board
  • The importance of identifying a project lead
  • The RFP process - how it should and should not go
And William shares a story about a nonprofit that may or may not have still been using a typewriter. You don't want to miss this one!

Episode 2: From Socially Awkward to Socially Awesome! || daniellejohnson-76

According to Danielle Johnson, straight-shooting host of the Raise + Engage podcast series, if your staff members aren’t the number one advocates for your cause on social media, you’re failing. In the most recent episode, Danielle is joined by Blackbaud’s own social media guru Madeline Turner to discuss overcoming social struggles and creating a social ambassador program at your organization. This entertaining and insightful duo dishes on the importance of making your social media presence human, making the case for a formal social program to leadership, how University of Michigan turned a one time social media campaign into a long term social program, and how Madeline's mom unknowingly became a social ambassador on #GivingTuesday.

Episode 1: Corporate Culture & Development: Shake It Up! || daniellejohnson-76

In the premiere episode of Raise & Engage, Danielle is joined by three straight-shooting nonprofit rock-stars: Jodi Smith of Sanford Health Systems, Veronica Brown of Chicago Public Library Foundation and Ali Burke of Southlake Regional Health Centre Foundation. The group talks organizational culture, problem employees, why its important to celebrate and how to shake things up this year and build a better more authentic team that gets stuff done!


Stay informed, catch latest trends in the nonprofit space.

Subscribe to Our Free Newsletter

No obligation, unsubscribe at anytime.

Success! Check your email inbox.

Follow Us On Twitter

NPT 2016 Buyers' Guide

Newsletter Sign-up

click here to return to the previous page