Migration of EXCEL-based metadata to an interface in a PostgreSQL database

The data model has already been realised for the most part, with some adjustments leading to its refinement. The visualisation and processing of the data can be carried out with little effort via an already existing, customer-internal application. For the technical description of the transfer logic, several discussions have to be held with the specialist department, in which the database team also participates to ensure the technical feasibility. The migration is carried out separately for each department. The transfer always takes place on a test database first. The technical department randomly checks the field assignments visually, but also by comparing the original with the Excelexport from the database, until a status that meets all requirements is achieved. Very helpful and effective in this task is the knowledge from other projects in which the affected interface is explicitly populated/called.