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

so you said I need to install ora2pg on both servers, oracle db and postgres db?
thank you. Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely rich *** Faithful talent *** Sharing success

On Wednesday, January 16, 2019 3:55 PM, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

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.