PJ Hyett has created an impressive plugin for Ruby on Rails, called auto_migrations.
It deduces changes between the db/schema.rb and the current database schema, and executes the appropriate commands to bring the latter in sync with the former. It supports creating tables, adding, changing, and removing fields, adding and removing indexes. It also allows you to create the real migrations based on schema changes.
Read more at author’s blog: Err the Blog: “Automatically”.
Recent posts on similar topics
- Garry Dolley: "Capistrano 2.0 with Git shared repository" - September 14th, 2007
- developerworks: "DB2 Change Management Expert" - June 24th, 2007
- Xaprb: "So you think your code is in version control?" - January 16th, 2007
- Overview: database schema version control - November 5th, 2006
- Overview: database schema version control - November 5th, 2006