database migration code generator

I want to introduce database migrations into my project and would like to be able to ge开发者_Go百科nerate my initial migration scripts from the database. I was wondering if there are any code generation tools around to do this? I was thinking of using migrator.net but am happy to use anything so long as I can get a tool to generate code for it.

Wizardby can perform reverse-engineering of existing database schema.

Data Dude (ie: Visual Studio Team System Database Edition) does a very, very good job of this. It allows automatic migration code generation through multiple versions, as well as building full scripts off an existing DB.

Fluent Migrator can do this now too

http://computeristsolutions.com/blog/posts/2011/4/dumping-existing-schema-with-fluentmigrator