Re: Oracle and PostgreSQL

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(at)commandprompt(dot)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(at)commandprompt(dot)com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL