I like to use xml as interchange format between different databases. The xml format is standardized (xsd) and also the database schema is pretty fix.
My tasks now is to map between those worlds. Is there a kind of "mapper" to transform xml to sql databases in a bidirectional manner? I like something similar to the mapping files used in NHibernate.
At the moment I map from object to database using NHibernate. Now I like to map the Database to xml using a slightly different object structure.
Machine 1 export: DB -> XML Machine 2 import: XML -> DB
Both steps with a fix and slightly different mapping.
My prefered language and DB is C# and postgresql using NHibernate as a OR-Mapper.
Another restriction is that i would like to have the objects of both sides (database/xml) separate, so that the database types need not to be serializable.
Thanks!