1

I have lots of data to be exported from one machine and imported into another. Therefore I need to write a Java application to export the entire database along with its data and then run another java code to import it into another machine. I saw ddlutils but it doesn't seem to have an official release yet. Also examples in there are not explanatory enough for a beginner. Is there a way to do this? Any code samples would be much appreciated.

Vadim Kotov
  • 8,084
  • 8
  • 48
  • 62
AnOldSoul
  • 4,017
  • 12
  • 57
  • 118
  • instead of re-inventing the wheel .... try using any existing ETL tool ... for example Talend – Lav Apr 20 '16 at 07:33
  • Is it just "take all the data of A and copy them to B" or is merging with already existing data (at B) required? – Fildor Apr 20 '16 at 07:33
  • 1
    I don't see any benefits doing it in java instead of on the db side itself with a bkp or something. Unless you want to edit a bunch of the data in the proccess. – dambros Apr 20 '16 at 07:34
  • @Fildor If there are data already available, then I should merge it. Else I need to insert them fresh – AnOldSoul Apr 20 '16 at 07:37
  • @mayooran I still think it is simply easier (and way faster since you don't need to read every data in Java) to do something like [this](http://stackoverflow.com/questions/10028805/transfer-data-from-one-database-to-another-database) – dambros Apr 20 '16 at 08:01
  • If you only want an exact copy of the whole database, you simply can copy the database folder. – vanje Apr 20 '16 at 10:48

0 Answers0