基于多系统数据库结构的复制/更新最佳实践

so after searching and not finding similar cases I want to open a new question. So here is the case: We are working with a large database with a very complicated data structure. Also we are working on multiple systems to ensure stability (development, testing, quality and productive) and its always a struggle so move data between those systems. As I said the data structure is very large and there is also a lot of logic inside the database. Customers are able to add new data parts as configuration and there is also a static income of data which are used for statistics and monitoring. So let me explain the problem with a small example:so after searching and not finding similar case