Re: Oracle and PostgreSQL

On Thu, Jan 27, 2005 at 03:32:38PM -0200, Bruno Almeida do Lago wrote:
> Hello my friends,
>
> We are going to change some Oracle 8i and 9i databases to PostgreSQL
> 8 at my company.
>
> 1st: 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).

It depends how much of Oracle's functionality you used. Do you have
table types or other exotics like custom types?

> 2nd: Which tools are available to do it? I've seen one called SQL
> Fairy (http://sqlfairy.sourceforge.net/) Is this one the most
> recommended?

Try it and see.

> 3rd: Is there a way to make both databases talk (such as creating a
> DBLink between two Oracle Databases)?

Yes! For all-PostgreSQL environments, use contrib/dblink. For
heterogeneous environments, there's

http://pgfoundry.org/projects/dbi-link/

Please send bug reports/feature requests for DBI-Link if needed.

> 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) but
> I'd like to see other comparsions like in real production databases.

The best benchmark, of course, is your application.

Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!