Re: A way to link oracle DB to postgres DB for data transfer

From: Medi Montaseri <medi(dot)montaseri(at)intransa(dot)com>
To: David Griffiths <dgriffiths(at)boats(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: A way to link oracle DB to postgres DB for data transfer
Date: 2002-10-25 17:59:14
Message-ID: 3DB98672.70805@intransa.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)montaseri(at)intransa(dot)com>
>To: "David Griffiths" <dgriffiths(at)boats(dot)com>
>Cc: <pgsql-general(at)postgresql(dot)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(dot)Sanusi(at)seagate(dot)com>
>>>To: <pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org)
>>>
>>>
>>>
>>>
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 3: if posting/reading through Usenet, please send an appropriate
>>subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>>message can get through to the mailing list cleanly
>>
>>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Paul Ottar Tornes 2002-10-25 18:03:22 [General] Warning: Unable to connect to PostgreSQL server: unknown host name:
Previous Message Hervé Piedvache 2002-10-25 17:54:40 Re: question about seq scan and index scan