Take the tour ×  For a future project I need to use the
following setup: Some small (offline) data boxes (colleting data
over the time) fill PostgreSQL databases. (Summing up to about 1
TB a year. For time to time, I would have the chance to move
data out of those boxes (onto a stick or mobile drive) and
import that into a huge corporate Oracle database. So far, this
is hopefully not a really bad solution. At the moment I'm
looking for things to be prepared for easy use later. Has anyone
ever done things like that?    • Experiences, what to do and
what to prevent?   • Any other campatibility   • Things to do in
advance?   • How to move the data? Special dump-settings?
share|improve this question add comment  1 Answer  Learn and use
an ETL tool  You'll save yourself a lot of time and pain if you
use ETL tools like Pentaho Kettle or Talend Studio to automate
the data transfer and merging. They'll happily connect to the Pg
instance and the Oracle instance and do the required copying and
merging using quite flexi