views:

48

answers:

0

I've used South migrations in the past, but am now looking for a database migration tool that is not tied to a particular framework or Object Relational Mapper (South is for Django). I need it simply for managing schema updates (and rollbacks) and nothing else. Various tools and applications use the same database, so I'd like a dedicated tool to manage the schema and not have it integrated with the ORM of one particular web-application that might use the shared DB.

Edit: To clarify, I don't need a tool that reads changes to models in an app and generates the schema updates for me. I want a tool that uses migrations and applies updates and rollbacks on request, but where I explicitly write the update and rollback actions myself. Basically a better managed, and slightly abstracted version of sourceing .sql scripts to do schema upgrades.

Preferably Python-based, as that is what the team is familiar with, the tool needs to work with MySQL but would hopefully also have some abstraction for other RDBMS backends.

Obviously I could find a few myself and but I'd like to harness the experience of the community here to shortcut the process a little by gathering some "reviews" from personal experience using the tools in real world scenarios. What are the good things about the solution, what are the pitfalls and problems you've encountered with it, is it actively developed, does it have a good community, support etc?

So far I've found yoyo-migrations which looks promising, but no info from anyone using it.