Re: A way to link oracle DB to postgres DB for data transfer - Mailing list pgsql-general
From | Medi Montaseri |
---|---|
Subject | Re: A way to link oracle DB to postgres DB for data transfer |
Date | |
Msg-id | 3DB98672.70805@intransa.com Whole thread Raw |
In response to | A way to link oracle DB to postgres DB for data transfer (Zuhra.Sanusi@seagate.com) |
List | pgsql-general |
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 > >
pgsql-general by date: