How can I generate "migration" DDL from NHibernate mapping files?

Question

I'm using NHibernate 2 and PostgreSQL in my project. SchemaExport class does a great job generating DDL scheme for database, but it's great until the first application.

Is there any way to generate "migration" DLL (batch of "ALTER TABLE"'s instead of DROP/CREATE pair) using NHibernate mapping files?

Answer 1

Look into SchemaUpdate. Very similiar API as SchemaExport but it only creates migrations.