jasondcamp / pyway

A Flyway like migration manager written in python.
GNU General Public License v3.0
20 stars 9 forks source link

Support migration from flyway #62

Open walterheck opened 2 months ago

walterheck commented 2 months ago

I got started with flyway (because I used it back in the day in some project and it nicely did it's thing), then realised that it's semi-ideal in a python app. Some searching landed me on pyway.

It would be nice to be greeted in the docs with a "Migrating from flyway to pyway? Do this:" type of thing. Now I am not sure (but pretty sure ;) ) if pyway requires any changes to the sql baseline schema and/or migrations. And for instance the table I have in my schema to track the version it's on, is that okay or does it need work?

thanks in advance!

jasondcamp commented 2 months ago

Hi Walter, I appreciate your comments thanks! To be clear, pyway was not designed to be fully backwards compatible with flyway. That said, I agree that some sense of compatibility should be there and some explanations at least about what pyway does not support that flyway does support. I can work on this and keep you updated. I think as of today though, it's safe to assume that the version schema is not compatible with pyway, but depending on how many migrations you have, you can easily import them in without re-applying them and they'll at least be in the version database to track. Thanks again! Jason