NHibernate - Generate Domain from Database

Question

I know its possible to generate the database tables from the domain model. But is there any way of doing things the other way. I have a totally awful database (worst I have ever seen). Its sharded (16 Shards!!), split across multiple postgres databases (all on the same server) with foreign key relations like urn:dbtable:guid.

Its proving a major pain in the ass to migrate using SSIS so I want to use NHibernate, read the data into objects and rewrite to a SQL Server database in blissful data-architectural harmony.

Is there any way to scan the current DB using NH or other and build a domain model and mappings?

Thanks!

Answer 1

There are commercial tools available that can generate everything from the DB model.

Check http://nhforge.org/wikis/general/commercial-product-ecosystem.aspx

Answer 2

NHibernate Mapping Generator
- A simple utility to generate NHibernate mapping files and corresponding domain classes from existing DB tables

It's free.