Re: Copying Data from Oracle to PostgreSQL

I think you are somewhat confused about how you need to set it up:

ora2pg needs to have access to both Oracle Client and PostgresSQL client in
order to talk to the origial (Oracle) and the new (Postgres) database.

This means you don't need to install the software on both servers, in fact
you could use it in a third machine (which I recommend).

The setup would look like:

A: Original Oracle server.

B: New Postgres server.

C: Processing server, which will do the hard work of pulling and pushing
the data.

ora2g, as well as the Postgres and Oracle client are installed on C, and
from here it connects to the Oracle on A, proccesses the data and sends it
to the Postgres on B. Once you are done you can even completely discard
this server.

On Thu, Jan 17, 2019 at 10:23 AM Pepe TD Vo <pepevo(at)yahoo(dot)com> wrote:

> Shreeyansh,
>
> Thank you for your input. I installed ora2g on both Oracle DB and
> Postgresql DB servers. Since these two servers are main database servers,
> do I still need install extra Oracle Client and PostgreSQL client on that
> each two servers?
>
> thank you.
>
> v/r,
>
>
>
> *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 Thursday, January 17, 2019 4:01 AM, Shreeyansh Dba <
> shreeyansh2014(at)gmail(dot)com> wrote:
>
>
> On Thu, Jan 17, 2019 at 1:35 AM Pepe TD Vo <pepevo(at)yahoo(dot)com> wrote:
>
> I am able to download the ora2pg but I don't understand how it install.
> According to the document I found on net that yum install perl-DBD,
> perl-dev, and perl-CPAN and all
> oracle-instantclient18.3-sqlplus-18.3.0.0.0-1.x86_64.rpm, oracle-instantclient18.3-basic-18.3.0.0.0-1.x86_64.rpm, oracle-instantclient18.3-basic-18.3.0.0.0-1.x86_64.rpm, oracle-instantclient18.3-devel-18.3.0.0.0-1.x86_64.rpm, oracle-instantclient18.3-devel-18.3.0.0.0-1.x86_64.rpm.
>
> 1. I can't find the ora2pg18.2 on gzip or zip but bz2. With this file
> I can't unzip it because the server didn't have this feature. Can I use
> ora2pg.19.1.tar.gz instead of version 18?
>
> You can download the ora2pg18.2 on zip or tar.gz from below link.
> https://github.com/darold/ora2pg/releases
> <https://github.com/darold/ora2pg/releases>
>
> 2. Where should I install ora2pg, in the oracle db server or postgres
> db server?
>
> You can install ora2pg either Oracle server or PostgreSQL sever or
> elsewhere. But must be have installed the Oracle Client Application and
> PostgreSQL Client (psql) Application on that server.
> Thanks & Regards,
> *Shreeyansh DBA Team*
> www.shreeyansh.com
>
>
> thank you for your inputs.
>
> v/r,
>
>
>
> *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 Friday, January 11, 2019 11:42 AM, Shreeyansh Dba <
> shreeyansh2014(at)gmail(dot)com> wrote:
>
>
> This site works for us, there might be a security restriction at your end.
>
> Thanks & Regards,
> *Shreeyansh DBA Team*
> www.shreeyansh.com
>
>
> On Fri, Jan 11, 2019 at 10:04 PM Pepe TD Vo <pepevo(at)yahoo(dot)com> wrote:
>
> Yes, I need migrate all the objects including tables, functions, triggers,
> procedures from Oracle to Postgres. Oracle is on one server and Postgres
> is on another server.
>
> https://ora2pg.darold.net/documentation.html doesn't work. "
> This site can’t be reached
> *ora2pg.darold.net <http://ora2pg.darold.net/>* took too long to respond.
> Try:"
>
>
> 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 Friday, January 11, 2019 11:31 AM, Shreeyansh Dba <
> shreeyansh2014(at)gmail(dot)com> wrote:
>
>
> Hi,
> You can use ora2pg which is one of the best tool for data migration from
> Oracle to PostgreSQL.
>
> https://ora2pg.darold.net/documentation.html
>
> Thanks & Regards,
> *Shreeyansh DBA Team*
> www.shreeyansh.com
>
>
> On Fri, Jan 11, 2019 at 9:53 PM Pepe TD Vo <pepevo(at)yahoo(dot)com> wrote:
>
>
> Hi Experts,
>
> Is there a best tool for me to copying data from Oracle to PostgreSQL?
> The Oracle db named is Cidr and had a few schemas, each schemas owned
> their own tables, procedures, triggers, functions. If I create a database
> on Postgres, how do I copy all schemas from Oracle? Or each schema will
> become one of the postgreSQL database?
>
> thank you for your helps.
>
> v/r,
>
> 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
>
>
>
>
>
>
>
>