search

victorstanciu / dbv

Database version control, made easy!
http://dbv.vizuina.com
1.69k stars 247 forks source link

Integration with dbdiff #100

Open crirus opened 7 years ago

crirus commented 7 years ago

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 commented 7 years ago

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 commented 7 years ago

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