I don't see the problem. Each branch has its own desired state as necessary. A different database version is going to need a different migration script, no matt

I don't see the problem. Each branch has its own desired state as necessary. A different database version is going to need a different migration script, no matter what your approach. Only difference is whether you generate those scripts by direct comparison with prod directly or with a crude reconstruction of it.