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 rest of this blog post, we discuss Data Migrations, a specific activity in consolidating tech stacks. We will cover some of the key questions your team should ask as you plan for 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:
This 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 always 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 in the loop on your project and prepared to answer detailed questions.
A data migration project requires a high volume of touch points, 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 business you are merging with is using already one of these tools. Ensure that the teams working on this project have access to this information and that you’re regularly updating tasks, responsibilities, and deadlines.
If you follow an agile methodology, have team members estimate the effort required for tasks on a story level to help ensure success. The success of the project, as with any, relies on some basic principles that I like to apply to everything I do:
These are the top questions our team asks when helping our clients start a data migration project. By thinking about these questions in advance, you’ll reduce the number of roadblocks during the project, and finish the project on time and on budget. Once you’ve completed this planning, move on learn about the 5 Elements of a Data Migration project!
Sign up for weekly OpFocus blog updates!