Converting from PostgreSQL to Oracle???

From: Chris Hoover <revoohc_at_gmail.com>
Date: Wed, 15 Jun 2005 13:29:49 -0400
Message-ID: <1d219a6f0506151029ddb96@mail.gmail.com>

Hey Everyone,

I've been given a rather exciting project on which to work.=20 Management wants to look at migrating one of our large in house developed systems from PostgreSQL to Oracle. Does anyone know of any good sites with help on this type of conversion? Also, does anyone have any advice they can offer up?

Here is what we have:
~200 Postgresql DB's running between 5 systems (all schemas are the same, 1 db per customer)
DB's run from a ~100MB to ~100GB.

Any advice on how to go about this?

We have a lot of text, serial, and boolean columns that don't appear to map cleanly over to Oracle. What have some of you done in the past conveting these type of columns?

We are looking at either 9i (which we currenly have in house), or 10g for the Oracle server version.

Thanks,

Chris

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jun 15 2005 - 13:35:09 CDT