1

I have PHP, MySQL, and Mono installed.

I've been searching for an equivalent of Tarantino's Database script executable for MySQL and have failed miserably in finding something that will work. I don't want to use Liquibase because I find the dealing with tons of Xml extremely unappealing. I don't want to use DVS,because it seems to be way over kill for what I need. I don't want to install Ruby in order to use migrations either. I want the ability to just execute raw scripts like Tarantinos.

Does anyone know of a good one to use or am I going to have to end up rolling my own?

James
  • 680
  • 2
  • 8
  • 22
  • Have a look at http://dbv.vizuina.com/. It's not much, but I've been using it for quite some time now. Disclaimer: I made it. – Victor Stanciu Jun 13 '13 at 14:08
  • I actually already looked at that, but seemed a bit over-kill for what I needed. I went ahead and rolled my own which you can see below and it solves all my problems. Thanks though! – James Jun 13 '13 at 14:35

1 Answers1

0

Have a look at Doctrine Migrations http://www.doctrine-project.org/projects/migrations.html

I've been using it in one of my projects, and it is working quite nicely. You just maintain php files that are classes that have the sql files to run against the DB. There is one simple table that tracks what version the db is currently on.

adear11
  • 935
  • 6
  • 11
  • Unfortunately I am had some issues with Doctrine Migrate that I couldn't get past, it doesn't seem to be in a usable state for standalone execution at the moment. http://stackoverflow.com/questions/17004082/doctrine-migrations-there-are-no-commands-defined-in-the-namespace – James Jun 09 '13 at 03:32
  • Yeah, I had that same problem with it. Forgot about that. There's a pull request on the repo to fix it. The file structure for the dependencies has changed, so the build file for the phar needs to be updated. – adear11 Jun 09 '13 at 03:46
  • Ah, well feel free to use the one I made. It's sweet, simple, and gets the job done. :) – James Jun 09 '13 at 03:51