Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL

On Wed, Jan 16, 2019 at 1:35 PM Pepe TD Vo <pepevo(at)yahoo(dot)com> wrote:
> Need to download oracl-fdw?

oracle-fdw is PostgreSQL Server software that allows the PostgreSQL
server to connect to the Oracle database directly as a client. It can
move data but doesn't really deal with schema...it likely is something
you can forget and focus on migrating data and schema simultaneously
with a product designed to do just that (which ora2pg seems to be).

> I am asking where should I install ora2pg?

ora2pg is a piece of client software the uses both the standard Oracle
client application and the standard PostgreSQL client application
(psql) to perform its work. Basically (I've never actually used it)
it downloads the relevant data, using a normal client connection, from
the Oracle server to local files; processes those local files so that
they are now compatible with PostgreSQL; then uses psql to load the
newly transformed files into the PostgreSQL database. Local can be
any machine than can talk to the Oracle server (and has the Oracle
client) and can talk to the PostgreSQL server (and has the psql
client). Though even that requirement seems like it can be relaxed if
necessary. It likely should be neither server.

David J.