there is no one simple solution to solve yr problem.

There are many scenario that you can not incrementally transfer data from production to development.

Because you have no way to verify what you have copied will work according to the schema design (business rule).

If you know the schema well, you can probably write sql script to to copy a subset of ddata from production to test. However you may find you need to constantly changing this script as schema changed.

For my case, we probably like to do it the other way round. Duplicate the production data from one of the backup. And see what is needed to bring the production to the latest schema (this is always possible) as the development.

For testing data, do more test case and re-enter the data to the final database is also easy. Or check with the developer what is needed and do export-ikmport of part of the schema.

What do you think ?

Hope you can find yr best way to suit yr need.