For development typically I have used https://www.liquibase.org/ https://www.liquibase.org/. This is a change management tool for databases so devs can share th

For development typically I have used https://www.liquibase.org/ https://www.liquibase.org/. This is a change management tool for databases so devs can share the changes via source code and automate the databases upgrade process, but it also allows the addition of data in SQL form. You can use the tool to extract the existing structure and data from certain tables, so you can fairly easily automate the population of data and test data. I think it is a better approach to push changes from dev into test and then into production. Data might come back the other way but it is easier to deal with in a reviewable and selectable format as needing big dumps of it is specific to certain tasks and by no means most tasks. Developers will have different structures locally while they develop and once given the tools to refactor databases they do so. I think database dumps are a smell of a broken change management system every time I have seen them.