Is drizzle able to help ensure data parity between multiple environments?

[tylersayshi]

Let's say for example that I have a prod and dev environment. They both have the same schema, but I made a mistake in the dev environment and I would like to "reset" all of the data in my dev db with exactly what is in prod.

In a super simple use case I could write a script that deletes everything from dev and then ingests what is in prod. This gets orders of magnitude more difficult to do correctly when constraints exist on some of my table such that the order of insertion is more difficult to satisfy each of these constraints.

This seems like a kind of thing that drizzle kit could potentially help with, but I have not been able to find anything in the docs targeting this use case just yet.

Am I right in thinking this is something drizzle could help with? If not, what might be an alternative way to solve this?