database migration code generator

Question

I want to introduce database migrations into my project and would like to be able to generate 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.

Answer 1

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.

Answer 2

Wizardby can perform reverse-engineering of existing database schema.

Answer 3

Fluent Migrator can do this now too

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