Is there a standalone migration alternative using an activetecord-like scheme?
Is there a standalone migration alternative like activerecord. Something like a script that is capable of keeping track of the current version of the schema and applying outstanding migrations. Basically, these migration files can be just regular SQL files, for example:
[timestamp] _create_users.sql reverse_ [timestamp] _create_users.sql
The implementation language is not very important - it can be anything that is usually installed / pre-installed on * nix systems.
I tried to find something but couldn't. I might develop my own in an hour or two, but I'm just wondering - maybe something good is already there.
source to share
Try http://freshmeat.net/projects/liquibase/
If you are using MySQL on purpose, take a look at: http://www.mysqldiff.org/ I used this to synchronize the schema of the two databases (so you will need to apply the changes to the "master").
There's also http://phpmyversion.sourceforge.net/
source to share
Not a linux variant, but might answer this question for some people:
SQLYog can do this for MySQL - this is a Windows GUI tool:
It can (among other things) compare schemas and make one schema look like another, or generate the sql needed to do so if you want to. We use it to create sql patch files that we can use for updates. This is easier than manually maintaining the file when making design changes.
source to share
The ezComponents library has a database schema component that can compare and apply schema differences between two databases (or with a database and a file).
source to share
https://sourceforge.net/projects/migrations/
It is a tool for managing structural changes to database schemas based on Active Record migration from Rails. Features multiple schema interactions, runtime overrides, script generations, etc.
In addition, it has a command line interface and a graphical interface. It is also actively developing, and our company has been using it for over a year now, and this has greatly improved the life of every person from development to dbas to operations to optimize deployments and rollbacks. Management now accepts db changes (sometimes not very good) because thanks to this tool it is now automated.