Thread: 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
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 > 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: >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 >>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 > >>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: >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 > > >>>>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 > >