Suppose we are at a point where we have multiple databases that have schemas that are at a 90% similarity (That's just a random number to say that they're very similar, but not fully)
The reasons for those differences are not important at this stage, but the ORM supposes that the databases are the same when accessing/modifying data.
I now want to start versioning these databases, except that it's impossible at this stage to align them (or at least, let's say it is impossible)
What would be the best way to do this with flyway (community version) ?
I thought of having 2 baseline scripts stored separately, baseline my databases with those respectively, and have all the migrations under a common directory where flyway will be looking to apply them.
And if a new dev database needs to be created, I'll base it upon the prod's baseline script.
Are there any best/recommended practices when it comes to doing this?
NOTE All of this is done using the community CLI
