A way to link oracle DB to postgres DB for data transfer
I need to transfer data that reside in my oracle database to my postgres
database on a specific interval.
So, is a way to create a link between the oracle DB and the postgres DB
for data transfer usage.
If I were to do it between 2 oracle database , I could have done via a
DBLINK.
I would greatly appreciate if someone could give me pointers on how to get
this done.
Thank you. Any help is greatly appreciated.
Regards
Zuhra Sanusi
I don't know about DB specific.. and their might be a better way.. but
couldn't you just dump the data to file in a specific format/order and
cp to wherever postgres is running and have a script that reads it back
in?
Travis
-----Original Message-----
From: Zuhra.Sanusi@seagate.com [mailto:Zuhra.Sanusi@seagate.com]
Sent: Thursday, October 24, 2002 6:43 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] A way to link oracle DB to postgres DB for data
transfer
I need to transfer data that reside in my oracle database to my
postgres
database on a specific interval.
So, is a way to create a link between the oracle DB and the postgres DB
for data transfer usage.
If I were to do it between 2 oracle database , I could have done via a
DBLINK.
I would greatly appreciate if someone could give me pointers on how to
get
this done.
Thank you. Any help is greatly appreciated.
Regards
Zuhra Sanusi
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Import Notes
Resolved by subject fallback
Use JDBC - create a connection to each database and then copy data back and
forth from one connection to the other.
David
----- Original Message -----
From: <Zuhra.Sanusi@seagate.com>
To: <pgsql-general@postgresql.org>
Sent: Thursday, October 24, 2002 4:42 PM
Subject: [GENERAL] A way to link oracle DB to postgres DB for data transfer
I need to transfer data that reside in my oracle database to my
postgres
Show quoted text
database on a specific interval.
So, is a way to create a link between the oracle DB and the postgres DB
for data transfer usage.If I were to do it between 2 oracle database , I could have done via a
DBLINK.I would greatly appreciate if someone could give me pointers on how to get
this done.Thank you. Any help is greatly appreciated.
Regards
Zuhra Sanusi---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Or write a DB Synchronizer written in Perl using DBI::Pg and DBI::Oracle.
Perl is not a strongly typed language, as such it provides the best canvas
for intercultural relationships....
David Griffiths wrote:
Show quoted text
Use JDBC - create a connection to each database and then copy data back and
forth from one connection to the other.David
----- Original Message -----
From: <Zuhra.Sanusi@seagate.com>
To: <pgsql-general@postgresql.org>
Sent: Thursday, October 24, 2002 4:42 PM
Subject: [GENERAL] A way to link oracle DB to postgres DB for data transferI need to transfer data that reside in my oracle database to my
postgres
database on a specific interval.
So, is a way to create a link between the oracle DB and the postgres DB
for data transfer usage.If I were to do it between 2 oracle database , I could have done via a
DBLINK.I would greatly appreciate if someone could give me pointers on how to get
this done.Thank you. Any help is greatly appreciated.
Regards
Zuhra Sanusi---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
Yes, Perl is an option.
Perl is not a strongly typed language, as such it provides the best canvas
for intercultural relationships....
Provide options, not opinions. I could have just as easily said,
"Use Java if you are familiar with C, C++ or any other standard language.
Use Perl if your parents are brother and sister, or you've suffered a
dehabilitating brain injury..."
David.
----- Original Message -----
From: "Medi Montaseri" <medi.montaseri@intransa.com>
To: "David Griffiths" <dgriffiths@boats.com>
Cc: <pgsql-general@postgresql.org>
Sent: Thursday, October 24, 2002 5:25 PM
Subject: Re: [GENERAL] A way to link oracle DB to postgres DB for data
transfer
Or write a DB Synchronizer written in Perl using DBI::Pg and DBI::Oracle.
Perl is not a strongly typed language, as such it provides the best canvas
for intercultural relationships....David Griffiths wrote:
Use JDBC - create a connection to each database and then copy data back
and
forth from one connection to the other.
David
----- Original Message -----
From: <Zuhra.Sanusi@seagate.com>
To: <pgsql-general@postgresql.org>
Sent: Thursday, October 24, 2002 4:42 PM
Subject: [GENERAL] A way to link oracle DB to postgres DB for data
transfer
I need to transfer data that reside in my oracle database to my
postgres
database on a specific interval.
So, is a way to create a link between the oracle DB and the postgres DB
for data transfer usage.If I were to do it between 2 oracle database , I could have done via a
DBLINK.I would greatly appreciate if someone could give me pointers on how to
get
Show quoted text
this done.
Thank you. Any help is greatly appreciated.
Regards
Zuhra Sanusi---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
Ooohhh strong reaction.....looks like I have touched you on the right
spot.....
I need not say any more, you Java programmers know you have lost it...
And since when Java is standard....
But I am too busy, you are right 100%, don't want any flame thread....
David Griffiths wrote:
Show quoted text
Yes, Perl is an option.
Perl is not a strongly typed language, as such it provides the best canvas
for intercultural relationships....Provide options, not opinions. I could have just as easily said,
"Use Java if you are familiar with C, C++ or any other standard language.
Use Perl if your parents are brother and sister, or you've suffered a
dehabilitating brain injury..."David.
----- Original Message -----
From: "Medi Montaseri" <medi.montaseri@intransa.com>
To: "David Griffiths" <dgriffiths@boats.com>
Cc: <pgsql-general@postgresql.org>
Sent: Thursday, October 24, 2002 5:25 PM
Subject: Re: [GENERAL] A way to link oracle DB to postgres DB for data
transferOr write a DB Synchronizer written in Perl using DBI::Pg and DBI::Oracle.
Perl is not a strongly typed language, as such it provides the best canvas
for intercultural relationships....David Griffiths wrote:
Use JDBC - create a connection to each database and then copy data back
and
forth from one connection to the other.
David
----- Original Message -----
From: <Zuhra.Sanusi@seagate.com>
To: <pgsql-general@postgresql.org>
Sent: Thursday, October 24, 2002 4:42 PM
Subject: [GENERAL] A way to link oracle DB to postgres DB for datatransfer
I need to transfer data that reside in my oracle database to my
postgres
database on a specific interval.
So, is a way to create a link between the oracle DB and the postgres DB
for data transfer usage.If I were to do it between 2 oracle database , I could have done via a
DBLINK.I would greatly appreciate if someone could give me pointers on how to
get
this done.
Thank you. Any help is greatly appreciated.
Regards
Zuhra Sanusi---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster