Create migrations of existing data

Migrations are really cool, but unlike in Ruby, most people still prefer to create/modify SQL in an appropriate database editor where you can actually see what you’re doing. But this makes migrations useless. It would be ideal to have a tool (commandline/gii) to create migrations on the fly. The tool could compare the current database with the last migration and generate a new migration file automatically.

This way, you could -for example- make git automatically run the script when pulling/pushing so you never have to worry about the database structure.

+1 on this one