All geek questions in one place

Import / export data into agnostic jdbc database?

Can agnostic tables / hydrates be made in general? I have no complex limitations. I also agree to db-specific ways, but the cleaner jdbc is, the better (I don't want to resort to impdp / expdp).

+3
source share
3 answers

Take a look at DBUnit . DBUnit supports export to xml file and import from XML file. Their faq contains some tips on how to quickly export / import, be sure to check this out.

+3
source

DBUnit , , , /. 100 000 , impdp/expdp.

, insert SQL-, sqlplus . [select 'insert into table values ​​(...' || column || '...)] sqlldr jdbc.

perl , .

0

If this is a small amount of data, some programs (such as Aqua Data Studio) can export the data as a series of SQL INSERT statements.

0
source

Source: https://habr.com/ru/post/1698502/

More articles:


All Articles