Integration with dbdiff

[crirus]

Hello

There is this command line php script that will take a source database and compare with a target database and produce sql script with UP / DOWN functionality for a revision.
https://github.com/DBDiff/DBDiff

I managed to put it in a composer style integration with DBV and with some small edits to DBV code one will be able to run either the generator for a version or up / down a new revision to target database.

[danbrellis]

Hey @crirus care to share what you've put together? I'm looking for a way to track db schema and data changes, but can't necessarily manually write each SQL revision script because I'm making edits to the data and schema via a CMS. I installed DBDiff locally and think it's a great way to generate the revision scripts, but if you've already found a way to integrate it with DBV that would be perfect!

Update: should have mentioned I'd be happy to work with you if there are still bugs or issues that need to be worked out.

[crirus]

There you go
https://github.com/crirus/DBRev