I used Migrator.NET for a long time with no problems and I'll probably still use it. But if you can afford it, SQL Source Control by Red Gate is awesome and integrates with your code repository, e.g. Mercurial.
I definitely cannot afford Red Gate's prices until funding.