Copying content from one DB to other DB.

Nitzer_Ebb · **Posted:** Thu Feb 23, 2006 5:26 am

I just wonder if Hibernate can be used in some way to make migration between different databases ?

For instance, I am having a Sybase DB, and I would copy the contents of this DB to a Oracle DB. Can this easily be achieved with Hibernate ?

If you have examples, or any other suggestions, please let me know.

Regards
/Andreas

jherbst · **Posted:** Sat Feb 25, 2006 6:19 pm

Hi,

of course you could use hibernate to migrate data from database to another, but thats not the kind of work hibernate was designed for. Hibernate wasn't made for handling large amounts of data, for batch operations or for handling import/export tasks. There are some improvements on hibernate 3(.1) handling batch operations, but you certainly should think about other ways solving you're problem.

Joerg

anthony · **Posted:** Sun Feb 26, 2006 7:25 am

take a look at session.replicate...