Anyone have any recommendations around tooling for managing database migrations?
I currently have one database and simply run migrations on application startup. However, I'm going to need to be managing databases in multiple regions and orchestrating migrations across them. I'm looking at using Pulumi to provision these databases, but not sure it's the right tool for actually managing the schemas.
My migrations are pure SQL (up.sql/down.sql). I don't want any tools that try to automatically generate migrations based on declarative changes, as I find them quite dangerous. I'm interesting in tools that would integrate closely with Pulumi, since Pulumi will be managing what databases actually exist, and migrations will need to be run when a database is first provisioned. It would be great if the tool could also be used to roll-back migrations via some kind of dashboard.