How to export/import data using hibernate tools?

BoBaH32 · **Joined:** Mon Sep 04, 2006 9:57 am **Posts:** 10

Is is possible to import / export data using hibernate tools?

caterham · **Posted:** Thu Sep 07, 2006 4:48 am

BoBaH32 wrote:

Is is possible to import / export data using hibernate tools?

I think this is not the business of Hibernate tools. If you use Oracle you have export/import tools delivered with your db. Or you can use TOAD or any other DB tool to create import/export data.

max · **Posted:** Thu Sep 07, 2006 4:26 pm

it is possible (we have all the technical parts for it) but not implemented.

what kind of import/export where you thinking about ?

note: <hql> allows you to run arbitrary queries and get it dumped to disc.

max · **Posted:** Thu Sep 07, 2006 4:29 pm

btw. i also agree that it is/should not be a primary goal for the tooling....but some type of export at least would inteersting.

BoBaH32 · **Joined:** Mon Sep 04, 2006 9:57 am **Posts:** 10

max wrote:

it is possible (we have all the technical parts for it) but not implemented.

what kind of import/export where you thinking about ?

I have to imort all tables data from PostgreSql and export it to MaxDB

max · **Posted:** Sat Sep 09, 2006 4:10 am

ok then I would something more low level like the raw import/export features of the db's (if they have that) and/or some jdbc db-copy utils.

BoBaH32 · **Joined:** Mon Sep 04, 2006 9:57 am **Posts:** 10

max wrote:

ok then I would something more low level like the raw import/export features of the db's (if they have that) and/or some jdbc db-copy utils.

Can you advice me something?

max · **Posted:** Mon Sep 11, 2006 3:37 am

just google for it.... i don't have any preferences except i normally look into the docs of the related dbs to find their optimized import/export functionallity and try and pair them up.

gskempes · **Joined:** Mon Nov 22, 2004 11:21 am **Posts:** 42

Have a look at Aqua Data Studio. They have a free personal/educational use licence and support many different databases. I was able to extract an Oracle-Database and create it as Firebird-Database (including structure!) with very low effort: http://www.aquafold.com/licensing.html

Please note: this is only a pointer. I'm not involved with the company Aquafold in any kind. There may be other and better tools in the web.

david · **Posted:** Wed Sep 13, 2006 7:58 pm

dbUnit can be applied to do this sort of thing as well.