title: Data transfer from one Database server to another in Java
body: <p>I don't really ask a lot of questions but This time, it's too much. Here's the problem.
  I have these two database (Sybase) servers and there's this database with over 90 tables but i need to archive only 20 tables. </p>
  
  <p>These tables are however quite large and can contain up to 90million records. So here's the deal. Currently, what I do is that</p>
  
  <ul>
  <li>For the big tables (alot of records), I create a temp table and copy from the temp table to the destination but running an insert for each statement.</li>
  <li>After the copying is done, i drop the temp table created. </li>
  </ul>
  
  <p>Now, I've tried other methods like for instance.</p>
  
  <ol>
  <li>Up to now, the multi threading is just okay but the speed of archival is not good enough. for instance, it can archive up to 1.6M records within  one hour. That is not good enough  for my Boss. </li>
  </ol>
  
  <p>Kindly advice on any other solution, approach or thought you'd think can help. Please not that all solutions are welcome. </p>
  
  <p>Thanks in advance.</p>