pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCopying Data from Oracle to PostgreSQL
20+ messages / 7 participants
[nested] [flat]
* Copying Data from Oracle to PostgreSQL
@ 2019-01-11 16:22 Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:28 ` Re: Copying Data from Oracle to PostgreSQL Don Seiler <don@seiler.us>
2019-01-11 16:29 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
0 siblings, 2 replies; 20+ messages in thread
From: Pepe TD Vo @ 2019-01-11 16:22 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Copying Data from Oracle to PostgreSQL
2019-01-11 16:22 Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
@ 2019-01-11 16:28 ` Don Seiler <don@seiler.us>
1 sibling, 0 replies; 20+ messages in thread
From: Don Seiler @ 2019-01-11 16:28 UTC (permalink / raw)
To: Pepe TD Vo <pepevo@yahoo.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Fri, Jan 11, 2019 at 10:23 AM Pepe TD Vo <pepevo@yahoo.com> wrote:
>
> 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?
>
If you just want to copy data, you could set up oracle_fdw and import the
data via a SELECT query from the foreign table(s). If you're looking to
migrate all of those objects (including procedures, functions, etc), then
you'll need something like ora2pg.
Don.
--
Don Seiler
www.seiler.us
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Copying Data from Oracle to PostgreSQL
2019-01-11 16:22 Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
@ 2019-01-11 16:29 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-11 16:34 ` Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
1 sibling, 1 reply; 20+ messages in thread
From: Shreeyansh Dba @ 2019-01-11 16:29 UTC (permalink / raw)
To: Pepe TD Vo <pepevo@yahoo.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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@yahoo.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
>
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Copying Data from Oracle to PostgreSQL
2019-01-11 16:22 Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:29 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
@ 2019-01-11 16:34 ` Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:40 ` Re: Copying Data from Oracle to PostgreSQL Don Seiler <don@seiler.us>
2019-01-11 16:40 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
0 siblings, 2 replies; 20+ messages in thread
From: Pepe TD Vo @ 2019-01-11 16:34 UTC (permalink / raw)
To: Shreeyansh Dba <shreeyansh2014@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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 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@gmail.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@yahoo.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
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Copying Data from Oracle to PostgreSQL
2019-01-11 16:22 Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:29 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-11 16:34 ` Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
@ 2019-01-11 16:40 ` Don Seiler <don@seiler.us>
1 sibling, 0 replies; 20+ messages in thread
From: Don Seiler @ 2019-01-11 16:40 UTC (permalink / raw)
To: Pepe TD Vo <pepevo@yahoo.com>; +Cc: Shreeyansh Dba <shreeyansh2014@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Fri, Jan 11, 2019 at 10:35 AM Pepe TD Vo <pepevo@yahoo.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. "
>
That site works just fine for me.
Don.
--
Don Seiler
www.seiler.us
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Copying Data from Oracle to PostgreSQL
2019-01-11 16:22 Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:29 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-11 16:34 ` Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
@ 2019-01-11 16:40 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-16 20:05 ` Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
1 sibling, 1 reply; 20+ messages in thread
From: Shreeyansh Dba @ 2019-01-11 16:40 UTC (permalink / raw)
To: Pepe TD Vo <pepevo@yahoo.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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@yahoo.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@gmail.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@yahoo.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
>
>
>
>
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Copying Data from Oracle to PostgreSQL
2019-01-11 16:22 Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:29 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-11 16:34 ` Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:40 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
@ 2019-01-16 20:05 ` Pepe TD Vo <pepevo@yahoo.com>
2019-01-16 20:08 ` Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL gilberto.castillo@etecsa.cu
2019-01-17 08:59 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
0 siblings, 2 replies; 20+ messages in thread
From: Pepe TD Vo @ 2019-01-16 20:05 UTC (permalink / raw)
To: Shreeyansh Dba <shreeyansh2014@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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.
- 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?
- Where should I install ora2pg, in the oracle db server or postgres db server?
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@gmail.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@yahoo.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 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@gmail.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@yahoo.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
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL
2019-01-11 16:22 Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:29 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-11 16:34 ` Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:40 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-16 20:05 ` Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
@ 2019-01-16 20:08 ` gilberto.castillo@etecsa.cu
2019-01-16 20:17 ` Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
1 sibling, 1 reply; 20+ messages in thread
From: gilberto.castillo@etecsa.cu @ 2019-01-16 20:08 UTC (permalink / raw)
To: Pepe TD Vo <pepevo@yahoo.com>; +Cc: Shreeyansh Dba <shreeyansh2014@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
Hello
You may to use oracle_fdw
El 2019-01-16 15:05, Pepe TD Vo escribió:
> 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.
>
> * 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?
> * Where should I install ora2pg, in the oracle db server or postgres
> db server?
>
> 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@gmail.com> wrote:
>
> This site works for us, there might be a security restriction at your
> end.
>
> Thanks & Regards,
> SHREEYANSH DBA TEAM
> www.shreeyansh.com [2]
>
> On Fri, Jan 11, 2019 at 10:04 PM Pepe TD Vo <pepevo@yahoo.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 [1] 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@gmail.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 [2]
>>
>> On Fri, Jan 11, 2019 at 9:53 PM Pepe TD Vo <pepevo@yahoo.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
>
>
>
> Links:
> ------
> [1] http://ora2pg.darold.net/
> [2] http://www.shreeyansh.com/
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL
2019-01-11 16:22 Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:29 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-11 16:34 ` Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:40 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-16 20:05 ` Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-16 20:08 ` Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL gilberto.castillo@etecsa.cu
@ 2019-01-16 20:17 ` Pepe TD Vo <pepevo@yahoo.com>
2019-01-16 20:23 ` Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL gilberto.castillo@etecsa.cu
0 siblings, 1 reply; 20+ messages in thread
From: Pepe TD Vo @ 2019-01-16 20:17 UTC (permalink / raw)
To: gilberto.castillo@etecsa.cu <gilberto.castillo@etecsa.cu>; +Cc: Shreeyansh Dba <shreeyansh2014@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
sorry to ask, what is oracle_fdwdo I need to download this oracle_fdw and where should I install it, on oracle server or postgresql server?
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 Wednesday, January 16, 2019 3:09 PM, "gilberto.castillo@etecsa.cu" <gilberto.castillo@etecsa.cu> wrote:
Hello
You may to use oracle_fdw
El 2019-01-16 15:05, Pepe TD Vo escribió:
> 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.
>
> * 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?
> * Where should I install ora2pg, in the oracle db server or postgres
> db server?
>
> 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@gmail.com> wrote:
>
> This site works for us, there might be a security restriction at your
> end.
>
> Thanks & Regards,
> SHREEYANSH DBA TEAM
> www.shreeyansh.com [2]
>
> On Fri, Jan 11, 2019 at 10:04 PM Pepe TD Vo <pepevo@yahoo.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 [1] 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@gmail.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 [2]
>>
>> On Fri, Jan 11, 2019 at 9:53 PM Pepe TD Vo <pepevo@yahoo.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
>
>
>
> Links:
> ------
> [1] http://ora2pg.darold.net/
> [2] http://www.shreeyansh.com/
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL
2019-01-11 16:22 Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:29 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-11 16:34 ` Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:40 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-16 20:05 ` Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-16 20:08 ` Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL gilberto.castillo@etecsa.cu
2019-01-16 20:17 ` Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
@ 2019-01-16 20:23 ` gilberto.castillo@etecsa.cu
2019-01-16 20:35 ` Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
0 siblings, 1 reply; 20+ messages in thread
From: gilberto.castillo@etecsa.cu @ 2019-01-16 20:23 UTC (permalink / raw)
To: Pepe TD Vo <pepevo@yahoo.com>; +Cc: Shreeyansh Dba <shreeyansh2014@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
Answer interline.
El 2019-01-16 15:17, Pepe TD Vo escribió:
> sorry to ask, what is oracle_fdw
oracle_fdw is extension for pg (foreign data wrapper)
> do I need to download this oracle_fdw and where should I install it,
> on oracle server or postgresql server?
You can to install in pg server or wherever.
>
> 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 Wednesday, January 16, 2019 3:09 PM, "gilberto.castillo@etecsa.cu"
> <gilberto.castillo@etecsa.cu> wrote:
>
> Hello
>
> You may to use oracle_fdw
>
> El 2019-01-16 15:05, Pepe TD Vo escribió:
>> 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.
>>
>> * 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?
>> * Where should I install ora2pg, in the oracle db server or
> postgres
>> db server?
>>
>> 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@gmail.com> wrote:
>>
>> This site works for us, there might be a security restriction at
> your
>> end.
>>
>> Thanks & Regards,
>> SHREEYANSH DBA TEAM
>> www.shreeyansh.com [2]
>>
>> On Fri, Jan 11, 2019 at 10:04 PM Pepe TD Vo <pepevo@yahoo.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 [1]doesn't work. "
>>>
>>> THIS SITE CAN’T BE REACHED
>>>
>>> ORA2PG.DAROLD.NET [1] 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@gmail.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 [2]
>>>
>>> On Fri, Jan 11, 2019 at 9:53 PM Pepe TD Vo <pepevo@yahoo.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
>>
>>
>>
>> Links:
>> ------
>> [1] http://ora2pg.darold.net/
>
>> [2] http://www.shreeyansh.com/
>
>
>
> Links:
> ------
> [1] https://ora2pg.darold.net/documentation.html
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL
2019-01-11 16:22 Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:29 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-11 16:34 ` Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:40 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-16 20:05 ` Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-16 20:08 ` Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL gilberto.castillo@etecsa.cu
2019-01-16 20:17 ` Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-16 20:23 ` Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL gilberto.castillo@etecsa.cu
@ 2019-01-16 20:35 ` Pepe TD Vo <pepevo@yahoo.com>
2019-01-16 20:55 ` Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 20+ messages in thread
From: Pepe TD Vo @ 2019-01-16 20:35 UTC (permalink / raw)
To: gilberto.castillo@etecsa.cu <gilberto.castillo@etecsa.cu>; +Cc: Shreeyansh Dba <shreeyansh2014@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
Need to download oracl-fdw? It's hard to go thru so many processes, need to download, transfer information to somewhere, ask for permission to burn into a CD/DVD, burn a CD/DVD, file a paperwork to move software from CD/DVD to server.
Is there a way I can use those software already downloaded and transferred to the server?I am asking where should I install ora2pg? on oracle db server or postgres db server? I saw DBD-Oracle-1.52 tar and DBD-pg-2.19.3.tar, http://ora2pg-samrat.blogspot.com/ but didn't say which one is install on which?
the information is not really clear and may you help me out?
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 Wednesday, January 16, 2019 3:23 PM, "gilberto.castillo@etecsa.cu" <gilberto.castillo@etecsa.cu> wrote:
Answer interline.
El 2019-01-16 15:17, Pepe TD Vo escribió:
> sorry to ask, what is oracle_fdw
oracle_fdw is extension for pg (foreign data wrapper)
> do I need to download this oracle_fdw and where should I install it,
> on oracle server or postgresql server?
You can to install in pg server or wherever.
>
> 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 Wednesday, January 16, 2019 3:09 PM, "gilberto.castillo@etecsa.cu"
> <gilberto.castillo@etecsa.cu> wrote:
>
> Hello
>
> You may to use oracle_fdw
>
> El 2019-01-16 15:05, Pepe TD Vo escribió:
>> 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.
>>
>> * 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?
>> * Where should I install ora2pg, in the oracle db server or
> postgres
>> db server?
>>
>> 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@gmail.com> wrote:
>>
>> This site works for us, there might be a security restriction at
> your
>> end.
>>
>> Thanks & Regards,
>> SHREEYANSH DBA TEAM
>> www.shreeyansh.com [2]
>>
>> On Fri, Jan 11, 2019 at 10:04 PM Pepe TD Vo <pepevo@yahoo.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 [1]doesn't work. "
>>>
>>> THIS SITE CAN’T BE REACHED
>>>
>>> ORA2PG.DAROLD.NET [1] 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@gmail.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 [2]
>>>
>>> On Fri, Jan 11, 2019 at 9:53 PM Pepe TD Vo <pepevo@yahoo.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
>>
>>
>>
>> Links:
>> ------
>> [1] http://ora2pg.darold.net/
>
>> [2] http://www.shreeyansh.com/
>
>
>
> Links:
> ------
> [1] https://ora2pg.darold.net/documentation.html
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL
2019-01-11 16:22 Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:29 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-11 16:34 ` Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:40 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-16 20:05 ` Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-16 20:08 ` Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL gilberto.castillo@etecsa.cu
2019-01-16 20:17 ` Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-16 20:23 ` Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL gilberto.castillo@etecsa.cu
2019-01-16 20:35 ` Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
@ 2019-01-16 20:55 ` David G. Johnston <david.g.johnston@gmail.com>
2019-01-16 23:34 ` Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-17 10:07 ` Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 2 replies; 20+ messages in thread
From: David G. Johnston @ 2019-01-16 20:55 UTC (permalink / raw)
To: Pepe TD Vo <pepevo@yahoo.com>; +Cc: gilberto.castillo@etecsa.cu <gilberto.castillo@etecsa.cu>; Shreeyansh Dba <shreeyansh2014@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
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).
> 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.
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL
2019-01-11 16:22 Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:29 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-11 16:34 ` Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:40 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-16 20:05 ` Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-16 20:08 ` Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL gilberto.castillo@etecsa.cu
2019-01-16 20:17 ` Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-16 20:23 ` Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL gilberto.castillo@etecsa.cu
2019-01-16 20:35 ` Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-16 20:55 ` Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL David G. Johnston <david.g.johnston@gmail.com>
@ 2019-01-16 23:34 ` Pepe TD Vo <pepevo@yahoo.com>
1 sibling, 0 replies; 20+ messages in thread
From: Pepe TD Vo @ 2019-01-16 23:34 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: gilberto.castillo@etecsa.cu <gilberto.castillo@etecsa.cu>; Shreeyansh Dba <shreeyansh2014@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
so you said I need to install ora2pg on both servers, oracle db and postgres db?
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 Wednesday, January 16, 2019 3:55 PM, David G. Johnston <david.g.johnston@gmail.com> 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).
> 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.
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL
2019-01-11 16:22 Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:29 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-11 16:34 ` Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:40 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-16 20:05 ` Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-16 20:08 ` Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL gilberto.castillo@etecsa.cu
2019-01-16 20:17 ` Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-16 20:23 ` Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL gilberto.castillo@etecsa.cu
2019-01-16 20:35 ` Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-16 20:55 ` Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL David G. Johnston <david.g.johnston@gmail.com>
@ 2019-01-17 10:07 ` Laurenz Albe <laurenz.albe@cybertec.at>
1 sibling, 0 replies; 20+ messages in thread
From: Laurenz Albe @ 2019-01-17 10:07 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; Pepe TD Vo <pepevo@yahoo.com>; +Cc: gilberto.castillo@etecsa.cu <gilberto.castillo@etecsa.cu>; Shreeyansh Dba <shreeyansh2014@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Copying Data from Oracle to PostgreSQL
2019-01-11 16:22 Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:29 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-11 16:34 ` Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:40 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-16 20:05 ` Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
@ 2019-01-17 08:59 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-17 13:23 ` Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
1 sibling, 1 reply; 20+ messages in thread
From: Shreeyansh Dba @ 2019-01-17 08:59 UTC (permalink / raw)
To: Pepe TD Vo <pepevo@yahoo.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Thu, Jan 17, 2019 at 1:35 AM Pepe TD Vo <pepevo@yahoo.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@gmail.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@yahoo.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@gmail.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@yahoo.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
>
>
>
>
>
>
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Copying Data from Oracle to PostgreSQL
2019-01-11 16:22 Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:29 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-11 16:34 ` Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:40 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-16 20:05 ` Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-17 08:59 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
@ 2019-01-17 13:23 ` Pepe TD Vo <pepevo@yahoo.com>
2019-01-17 13:33 ` Re: Copying Data from Oracle to PostgreSQL marcelo zen <mzen@itapua.com.uy>
0 siblings, 1 reply; 20+ messages in thread
From: Pepe TD Vo @ 2019-01-17 13:23 UTC (permalink / raw)
To: Shreeyansh Dba <shreeyansh2014@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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@gmail.com> wrote:
On Thu, Jan 17, 2019 at 1:35 AM Pepe TD Vo <pepevo@yahoo.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.
- 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
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@gmail.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@yahoo.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 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@gmail.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@yahoo.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
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Copying Data from Oracle to PostgreSQL
2019-01-11 16:22 Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:29 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-11 16:34 ` Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:40 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-16 20:05 ` Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-17 08:59 ` Re: Copying Data from Oracle to PostgreSQL Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-17 13:23 ` Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
@ 2019-01-17 13:33 ` marcelo zen <mzen@itapua.com.uy>
0 siblings, 0 replies; 20+ messages in thread
From: marcelo zen @ 2019-01-17 13:33 UTC (permalink / raw)
To: Pepe TD Vo <pepevo@yahoo.com>; +Cc: Shreeyansh Dba <shreeyansh2014@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
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@yahoo.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@gmail.com> wrote:
>
>
> On Thu, Jan 17, 2019 at 1:35 AM Pepe TD Vo <pepevo@yahoo.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@gmail.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@yahoo.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@gmail.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@yahoo.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
>
>
>
>
>
>
>
>
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Copying Data from Oracle to PostgreSQL
@ 2019-01-17 16:24 Pepe TD Vo <pepevo@yahoo.com>
2019-01-17 16:52 ` Re: Copying Data from Oracle to PostgreSQL David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 20+ messages in thread
From: Pepe TD Vo @ 2019-01-17 16:24 UTC (permalink / raw)
To: marcelo zen <mzen@itapua.com.uy>; +Cc: Shreeyansh Dba <shreeyansh2014@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
I don't have a 3rd server to install ora2pg to connect between two oracle and postgres db servers. Contract is not funded to get extra server(s) and/or training. Also, I don't think we need the 3rd server to install orag2/oracleclient/postgresqlclient, right? From the youtube I found, the instructor said we can install ora2g on the server c or no need too but I didn't hear he said where ora2g should be install, on oracle db server or postgres db server.
I ran the ora2pg-19.1.zip and unzip it. The perl Makefile.PL and make && make install ok, but when I run perl -mCPAN -e shell, I get an error on cpan (error file attached).
How can I create the DBD::Oracle? How to correct the CPAN url if there's no internet?
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 Thursday, January 17, 2019 8:33 AM, marcelo zen <mzen@itapua.com.uy> wrote:
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@yahoo.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@gmail.com> wrote:
On Thu, Jan 17, 2019 at 1:35 AM Pepe TD Vo <pepevo@yahoo.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.
- 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
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@gmail.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@yahoo.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 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@gmail.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@yahoo.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
Attachments:
run a perl script to create DBB Oracle error.docx (application/vnd.openxmlformats-officedocument.wordprocessingml.document, 21.4K) download
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Copying Data from Oracle to PostgreSQL
2019-01-17 16:24 Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
@ 2019-01-17 16:52 ` David G. Johnston <david.g.johnston@gmail.com>
2019-01-17 16:54 ` Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
0 siblings, 1 reply; 20+ messages in thread
From: David G. Johnston @ 2019-01-17 16:52 UTC (permalink / raw)
To: Pepe TD Vo <pepevo@yahoo.com>; +Cc: marcelo zen <mzen@itapua.com.uy>; Shreeyansh Dba <shreeyansh2014@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Thu, Jan 17, 2019 at 9:24 AM Pepe TD Vo <pepevo@yahoo.com> wrote:
> I don't have a 3rd server to install ora2pg to connect between two oracle and postgres db servers. Contract is not funded to get extra server(s) and/or training.
Assuming the existing Oracle server is in production I would recommend
you not install stuff there which only leaves the new PostgreSQL
server as an option given your apparent limitations.
That's likely that last I will say on the topic - I agree with
Laurenz's sentiments; You don't seem to be in a position to personally
fulfill this contract that you've been assigned and you need to
consider how to deal with that fact. You haven't even gotten to the
hard part yet and your hands are tied in ways they should not be
(i.e., the machine you are performing the work on, a newly created
virtual machine workstation ideally, should have internet access).
David J.
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Copying Data from Oracle to PostgreSQL
2019-01-17 16:24 Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-17 16:52 ` Re: Copying Data from Oracle to PostgreSQL David G. Johnston <david.g.johnston@gmail.com>
@ 2019-01-17 16:54 ` Pepe TD Vo <pepevo@yahoo.com>
0 siblings, 0 replies; 20+ messages in thread
From: Pepe TD Vo @ 2019-01-17 16:54 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: marcelo zen <mzen@itapua.com.uy>; Shreeyansh Dba <shreeyansh2014@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
this is not production server. We need to test out on development servers before playing with a real one. 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 11:52 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Thu, Jan 17, 2019 at 9:24 AM Pepe TD Vo <pepevo@yahoo.com> wrote:
> I don't have a 3rd server to install ora2pg to connect between two oracle and postgres db servers. Contract is not funded to get extra server(s) and/or training.
Assuming the existing Oracle server is in production I would recommend
you not install stuff there which only leaves the new PostgreSQL
server as an option given your apparent limitations.
That's likely that last I will say on the topic - I agree with
Laurenz's sentiments; You don't seem to be in a position to personally
fulfill this contract that you've been assigned and you need to
consider how to deal with that fact. You haven't even gotten to the
hard part yet and your hands are tied in ways they should not be
(i.e., the machine you are performing the work on, a newly created
virtual machine workstation ideally, should have internet access).
David J.
^ permalink raw reply [nested|flat] 20+ messages in thread
end of thread, other threads:[~2019-01-17 16:54 UTC | newest]
Thread overview: 20+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-01-11 16:22 Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:28 ` Don Seiler <don@seiler.us>
2019-01-11 16:29 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-11 16:34 ` Pepe TD Vo <pepevo@yahoo.com>
2019-01-11 16:40 ` Don Seiler <don@seiler.us>
2019-01-11 16:40 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-16 20:05 ` Pepe TD Vo <pepevo@yahoo.com>
2019-01-16 20:08 ` gilberto.castillo@etecsa.cu
2019-01-16 20:17 ` Pepe TD Vo <pepevo@yahoo.com>
2019-01-16 20:23 ` gilberto.castillo@etecsa.cu
2019-01-16 20:35 ` Pepe TD Vo <pepevo@yahoo.com>
2019-01-16 20:55 ` David G. Johnston <david.g.johnston@gmail.com>
2019-01-16 23:34 ` Pepe TD Vo <pepevo@yahoo.com>
2019-01-17 10:07 ` Laurenz Albe <laurenz.albe@cybertec.at>
2019-01-17 08:59 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-17 13:23 ` Pepe TD Vo <pepevo@yahoo.com>
2019-01-17 13:33 ` marcelo zen <mzen@itapua.com.uy>
2019-01-17 16:24 Re: Copying Data from Oracle to PostgreSQL Pepe TD Vo <pepevo@yahoo.com>
2019-01-17 16:52 ` David G. Johnston <david.g.johnston@gmail.com>
2019-01-17 16:54 ` Pepe TD Vo <pepevo@yahoo.com>
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