How to handle Migrations correctly

In this topic we will not learn how to write Migrations but to learn how to improve them:

1. You have to create them using the innodb storage engine to enable Transaction and to be able to run correctly your tests (rolling back, sandbox,..)

http://significantbits.wordpress.com/2007/03/22/make-sure-you-use-innodb-and-utf-8-when-creating-tables-through-migrations/

2. If you are dealing with a legacy database (old database), you have to run the task existing in this page to turn your table to inndb:

http://snippets.dzone.com/posts/show/4327

3. Here more details about top-secret tuned configuration for rails and migrations:

http://blog.evanweaver.com/articles/2007/04/30/top-secret-tuned-mysql-configurations-for-rails/

Tags: innodb, migrations, rails, testing