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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
