RE: [Rails] Migrations Vs SQL compare tools


One of the things I really like about fixtures is (as DHH said) you can revert back down to whatever version you like, make a change to the migration (for example, add a field you didn't know you needed), then revert back up to the current version. Then, I use fixtures to load all my sample data into my DEV DB and I am back in business...about 20 seconds from start to finish. I can't speak to how/if you can do that with SQL scripts, but I know it's a nice feature of migrations. It's also all done independent of the particular database, which is nice when you work with more than one (MySQL/PostgreSQL/etc.)