Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL
Date
Msg-id 8f324e2ad438cc8ed79203254c9522b1275ac6b0.camel@cybertec.at
Whole thread Raw
In response to Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
David G. Johnston wrote:
> On Wed, Jan 16, 2019 at 1:35 PM Pepe TD Vo <pepevo@yahoo.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).

You can use https://github.com/cybertec-postgresql/ora_migrator which
will migrate metadata as well using oracle_fdw.

Pepe, at your level of knowledge I would recommend that you hire a
consultant to help you, regardless if you want to use ora2pg or something else.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com



pgsql-admin by date:

Previous
From: malli
Date:
Subject: RE: archive command failed with exit code 1
Next
From: Shreeyansh Dba
Date:
Subject: Re: archive command failed with exit code 1