A new Fluent Migrator code generator now emits both Install and Upgrade migrations.

[Tony OHagan]

The code gen app I've just built adds many new features beyond the existing two code gen projects.

The main addition is that it can compare two versions of the same database and generate a set of upgrade migration classes.

This means you can now generate both full install and delta upgrade migrations that end up at exactly the same schema and migration version numbers.

It can also import and embed SQL scripts for other objects such as functions, stored procedures and views.

This means you only need to ship one DLL containing all code. 

I personally think this is **big win** for the Fluent Migrator project as you can now auto detect and generate most of your migration code.

Just use SQL Server as your primary reference database and then generate portable migrations for all your other supported databases.

Migrations can also include comments that show the previous definition of deleted or updated objects - very handy when checking changes!

Check out the README for full feature details:

•   https://github.com/tohagan/fluentmigrator/tree/FluentMigrator.SchemaGen/src/FluentMigrator.SchemaGen
  

I've made a few minor changes to the Fluent Migrator code including some bug fixes.

It would be nice to be able to merge the efforts done on the T4 code gen project to support additional schema readers.

My project could not justify this - so I focused on SQL Server 2008 only as the source database.

I also needed some specific features not supported by the existing implementations so my SqlServerSchemaReader class is a full re-write.

Feedback welcome.

Tony.

[Gunnar Liljas]

Great stuff! Have been thinking about creating something similar for quite some time, but now maybe I can focus on creating a different schema reader.

Excited to take a closer look now.

/G

--
You received this message because you are subscribed to the Google Groups "FluentMigrator Google Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to fluentmigrator-goog...@googlegroups.com.
To post to this group, send email to fluentmigrato...@googlegroups.com.
Visit this group at http://groups.google.com/group/fluentmigrator-google-group.
For more options, visit https://groups.google.com/groups/opt_out.