From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Pepe TD Vo <pepevo(at)yahoo(dot)com> |
Cc: | "gilberto(dot)castillo(at)etecsa(dot)cu" <gilberto(dot)castillo(at)etecsa(dot)cu>, Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL |
Date: | 2019-01-17 10:07:41 |
Message-ID: | 8f324e2ad438cc8ed79203254c9522b1275ac6b0.camel@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
David G. Johnston 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).
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
From | Date | Subject | |
---|---|---|---|
Next Message | Shreeyansh Dba | 2019-01-17 11:09:41 | Re: archive command failed with exit code 1 |
Previous Message | malli | 2019-01-17 10:04:52 | RE: archive command failed with exit code 1 |