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).
Many here have done a similar exercise. We are doing this now. There
are of course differences, but each individual conversion faces its own
hurdles. For example, if you are using partitioned tablespaces in
Oracle, PostgreSQL doesn't have that concept, so you'll need to do
something different. One point in PG's favor (and the reason we
selected it as our Oracle alternative) is that it handles some of the
non-standard SQL that makes Oracle so powerful (like allowing a complete
SQL statement where a column normally appears in a SELECT clause.)
>
> 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?
Take a look at ora2pg. It does a good job and migrating schema and
data.
>
> 3rd: Is there a way to make both databases talk (such as creating a
> DBLink between two Oracle Databases)?
There is a dblink contrib package for PG that allows two PG databases to
be linked. You probably won't ever get an Oracle DB to link to a PG
one. But it might be possible in the other direction, since the PG
dblink mechanism is pretty generic.
>
>
> 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
--
Guy Rouillier
