As companies grow by acquisition, the need to migrate systems and data becomes essential. Whether through rollups, mergers, or other acquisitions, companies face the challenge of consolidating multiple environments into one. This challenge can be daunting: there are a lot of unseen technical details to consider and decide. A properly prepared tech stack consolidation should result in:
The consolidation process can look and feel like moving into a new house with a partner or roommate. What will you bring? What will your partner bring? How should the consolidated living situation look and feel in order to achieve the standard of living you seek?
In this blog post, we discuss Data Migrations, a key activity in consolidating tech stacks. We will cover some of the key questions your team should ask before starting a data migration, what to expect, and how to achieve maximum value in the future state.
In preparing for a data migration, there are a lot of questions that may race to your mind. Some of them may include:
The list of questions is not exhaustive. The purpose of this blog is to help you plan your migration project so that you can take on this endeavor and make the most informed decisions. We’re linking additional resources throughout the blog to provide further detail into specific topics.
Data Migration projects aren’t easy, but they can be rewarding. As part of the process, you have a chance to work out data challenges your organization might have been facing. On a recent tech stack consolidation, I worked on the configuration and data side of the project. In hindsight, I would have loved to have direct contact with team members from the companies whose business we were migrating from. It is difficult to understand business processes by only looking at the data, and we had to make a lot of assumptions. Having a business system analyst or someone who knew the business and the technology from the migrating company would have helped tremendously.
Without these users, we had to make some of our own conclusions. This back and forth with the acquiring company slowed down the project. If you have the ability to pull in experts from both companies, do so! In some cases, those team members may no longer be available to speak to. Either way, I encourage you to build an internal team that is supportive and is prepared to answer detailed questions.
A data migration project requires a high volume of touchpoints, discussions, and decisions. The volume of information can become overwhelming if not properly organized.
We recommend employing formal documentation and tool(s) to help track the requested information. Jira, Monday, Smartsheet, Excel, and other tools can meet this request. Oftentimes, your team or the other business sector it is merging with is using one of these. Ensure that the team working on this project has access to this information and is being updated.
Having the team members working on the changes estimate their tasks from a story level always helps to ensure success. This is implying you are following an agile methodology. The success of the project, as with any, relies on some basic principles that I like to apply to everything I do:
As you can see there are a number of questions your team should ask when starting a data migration project. By thinking about these questions thoroughly, you’ll reduce the number of roadblocks and finish the project in a more timely manner. Once you’ve completed this process you’ll want to move on to beginning your Data Migration project!
Sign up for weekly OpFocus blog updates!