is it possible to transfer the content of a database (e.g. MSSQL) into another database (e.g. Derby) with hibernate? both are mapped with the same mapping file.

Hi,

would you like to migrate MSSQL to Derby?

If that's right, has the structure changed?

If not use an export tool of MSSQL named bcp to generate dumps for each table and use a tool to from derby to load this dumps.

It's much more faster than using java.
I just migrate a MSSQL to Oracle.
With java I can insert 100 to 1000 rows per second
with bcp and sqlldr I can insert more than 20000 rows per second.

Best regards
Joerg

Thank you for your reply referring to my question.

I try to synchronize two databases at runtime as we need a (offline) backup database if our online connection interrupts.

At present we really try to resolve this using java which is, as you said, not very fast. Moreover, when copying our dataobjects, junction tables of bidirectional relations (many to many) are not transferred (we are investigating this problem).

This is why I ask if Hibernate has a fuction to transfer the content of two databases with the same structure.

Hibernate is great, but it's not really designed for this purpose in particular. Most databases have export and import tools that are fairly compatible. For more complex transfers those, you might want to look at some ETL tools such as IBM's DataStage.