OK! I've got to run now, but will search more about it tomorrow.
Could you give me more details / references?
> You don't want to do it automatically. You want to do it by hand but it
> isn't that hard.
Automatically? How?
About the link between the two databases, where can I find how to do it??
I'm very happy with the good news!
Thank you,
Teolupus
-----Original Message-----
From: Joshua D. Drake [mailto:jd@commandprompt.com]
Sent: Thursday, January 27, 2005 4:32 PM
To: Bruno Almeida do Lago
Subject: Oracle and PostgreSQL
> 1^st : Is there somebody who knows how to do it (had the same
> experience)? What are the limitations of this process (eg:
> incompatible data types and objects).
>
Command Prompt, Inc.
http://www.commandprompt.com
> 2^nd : Which tools are available to do it? I've seen one called SQL
> Fairy (http://sqlfairy.sourceforge.net/). Is this one the most
> recommended?
>
You don't want to do it automatically. You want to do it by hand but it
isn't that hard.
> 3^rd : Is there a way to make both databases talk (such as creating a
> DBLink between two Oracle Databases)?
>
Yes.
> And finally, do you know a good comparison chart or benchmark between
> these two databases? A Brazilian university teacher made one
> (http://www.ic.unicamp.br/~celio/livrobd/docs/benchmark.html
> <http://www.ic.unicamp.br/%7Ecelio/livrobd/docs/benchmark.html>) but
> I'd like to see other comparsions like in real production databases.
>
You can't legally benchmark between the two because of Oracles license.
Sincerely,
Joshua D. Drake
> C ya,
>
> Teolupus
>
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
