Automation of data manipulation before and after data migration

During a data migration, we are faced with the task of integrating this into a process with preparation and follow-up. These are
1. before the migration
1.1 prepare the data.
2. after the migration
2.1 transfer the entire table contents to the productive environment,
2.2. transfer individual data from the development environment to the production environment, e.g. for newly introduced settings fields and
2.3. set and update data manually after the migration

This process is made more difficult by the fact that there are actions that have to be carried out for every migration and there are actions that only have to be carried out for the next migration, as they affect newly created structures.

In addition, certain (completed) sites in the databases are to be transferred from the development environment to the production environment, but other sites "in progress" are not yet to be transferred. This knowledge lies with the employee who is responsible for the construction site.

In a team in which several people are allowed to carry out the migration and completed sites are to be migrated ASAP, it can become problematic to always communicate or document the relevant information correctly.

In response to this problem, we have developed a tool that not only records the tasks, but can also perform them automatically before and after a migration.