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:[EMAIL PROTECTED] 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 - [EMAIL PROTECTED] - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
