pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: David G. Johnston <david.g.johnston@gmail.com>
To: Pepe TD Vo <pepevo@yahoo.com>
Cc: gilberto.castillo@etecsa.cu <gilberto.castillo@etecsa.cu>
Cc: Shreeyansh Dba <shreeyansh2014@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL
Date: Thu, 17 Jan 2019 11:07:41 +0100
Message-ID: <8f324e2ad438cc8ed79203254c9522b1275ac6b0.camel@cybertec.at> (raw)
In-Reply-To: <CAKFQuwbt7jr9zuDE0jt6VGEFA=ytkTA8Qv3mTObT65nxEUo+pg@mail.gmail.com>
References: <1382151693.17038706.1547223778133.ref@mail.yahoo.com>
	<1382151693.17038706.1547223778133@mail.yahoo.com>
	<CAGDYbUOd=RJRPe7NyVpEjxOvEpsnpUiT0Qtu3vBYEO7uk_XvgQ@mail.gmail.com>
	<560782983.17074510.1547224489903@mail.yahoo.com>
	<CAGDYbUNt-ufg93qgAy-_x862c4W00T-YqZHkZXS+kw6118fEfQ@mail.gmail.com>
	<732616782.754403.1547669100729@mail.yahoo.com>
	<8b2bd545ff5c18410548e6e2fcb99a4e@etecsa.cu>
	<1492323826.781728.1547669875527@mail.yahoo.com>
	<d593e8b33d2aeabdb868093d6f2ff08c@etecsa.cu>
	<446111583.758900.1547670918954@mail.yahoo.com>
	<CAKFQuwbt7jr9zuDE0jt6VGEFA=ytkTA8Qv3mTObT65nxEUo+pg@mail.gmail.com>

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





view thread (20+ messages)  latest in thread

Message-ID: <8f324e2ad438cc8ed79203254c9522b1275ac6b0.camel@cybertec.at>
Permalink:  ../8f324e2ad438cc8ed79203254c9522b1275ac6b0.camel@cybertec.at/
Also on:    postgresql.org/message-id/8f324e2ad438cc8ed79203254c9522b1275ac6b0.camel@cybertec.at

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: laurenz.albe@cybertec.at, david.g.johnston@gmail.com, pepevo@yahoo.com, gilberto.castillo@etecsa.cu, shreeyansh2014@gmail.com
  Subject: Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL
  In-Reply-To: <8f324e2ad438cc8ed79203254c9522b1275ac6b0.camel@cybertec.at>
  References: <1382151693.17038706.1547223778133.ref@mail.yahoo.com> <1382151693.17038706.1547223778133@mail.yahoo.com> <CAGDYbUOd=RJRPe7NyVpEjxOvEpsnpUiT0Qtu3vBYEO7uk_XvgQ@mail.gmail.com> <560782983.17074510.1547224489903@mail.yahoo.com> <CAGDYbUNt-ufg93qgAy-_x862c4W00T-YqZHkZXS+kw6118fEfQ@mail.gmail.com> <732616782.754403.1547669100729@mail.yahoo.com> <8b2bd545ff5c18410548e6e2fcb99a4e@etecsa.cu> <1492323826.781728.1547669875527@mail.yahoo.com> <d593e8b33d2aeabdb868093d6f2ff08c@etecsa.cu> <446111583.758900.1547670918954@mail.yahoo.com> <CAKFQuwbt7jr9zuDE0jt6VGEFA=ytkTA8Qv3mTObT65nxEUo+pg@mail.gmail.com> <8f324e2ad438cc8ed79203254c9522b1275ac6b0.camel@cybertec.at>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox