A data warehouse migration is a significant challenge for companies to master. Executing a smooth data warehouse migration requires a thorough understanding of the requirements, tasks, possible challenges, risks, and creating a clear migration plan. At a high-level, your migration plan should include the data warehouse migration process, the various stages, and the various associated tasks within each stage.
This guide provides you with all the information you need to execute a data warehouse migration project.
A data warehouse migration project consists of three main phases - Preparation, Execution, and Go-live. The following image provides you with an overview of these phases:
Each phase consists of various activities that you need to perform for a data warehouse migration.
- Preparation: In the preparation phase, you define your migration team strategy, create an overview of your legacy data warehouse and its environment, and plan and prioritize the different iterations.
- Execution: In the execution phase, you create schemas, tables, users, etc., in Exasol. You load data, translate processes, and perform migration testing to validate and verify data completeness and accuracy.
- Go-live: In the go-live phase, you perform additional testing on the data, compare the data between the two data warehouses, decommission the legacy warehouse.
Available Migration Guides
The following migration guides are available:
If your migration source is missing, please contact us so we can help you.