| Lists: | pgsql-general |
|---|
| From: | "Bruno Almeida do Lago" <teolupus(at)gmail(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Oracle and PostgreSQL |
| Date: | 2005-01-27 17:32:38 |
| Message-ID: | 001a01c50496$37764330$e883f40a@br.gedasgrp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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).
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?
3rd: Is there a way to make both databases talk (such as creating a DBLink
between two Oracle Databases)?
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.
C ya,
Teolupus
| From: | David Fetter <david(at)fetter(dot)org> |
|---|---|
| To: | Bruno Almeida do Lago <teolupus(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Oracle and PostgreSQL |
| Date: | 2005-01-27 22:48:47 |
| Message-ID: | 20050127224847.GH2985@fetter.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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!