On Wed, Jan 16, 2019 at 1:35 PM Pepe TD Vo <pepevo@xxxxxxxxx> 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.
