I'm trying to copy a graph of hibernate objects from one database (PostgreSQL) to another (Oracle). Is there a recipe for doing this easily? I tried using merge() on each object while traversing the relationships but then the child objects keys don't match up. Do I basically have to do this by hand or is there an easy way?

Sam

in H3, session.Replicate should override any id generators

ofcourse, you always have the problem as noted here by Gavin. stupid databases.

http://forum.hibernate.org/viewtopic.ph ... 054ad380f0

you'd be better of nulling out all the id values of the children and just re-saving them in the new database allowing it to regenerate the values.