Data Knowledge
Before migration, the source data must be carefully audited. Unexpected errors may occur if this step is skipped.
Maintenance and protection
the data degrades after a certain time, and is therefore no longer reliable. To maintain data quality, controls must be provided.
“Big Bang” migration
the entire transfer is carried out over a limited period. Systems in production experience downtime as data goes through ETL processing and is transferred to the new database.
Cleaning
if errors are identified within the source data, they must be corrected. Depending on the scope of the work, additional software and third-party resources may be required.
Gouvernance
Data quality monitoring and reporting is important because it provides a better understanding of data integrity.
Migration « Trickle »
phased migration. During implementation, the new system and the old system are run in parallel, avoiding downtime or operational interruptions.