Re: Converting from PostgreSQL to Oracle???
- From: Jared Still <jkstill@xxxxxxxxx>
- To: revoohc@xxxxxxxxx
- Date: Wed, 15 Jun 2005 11:26:31 -0700
As long as you are doing a conversion, you should strongly
consider going straight to 10g.
Jared
On 6/15/05, Chris Hoover <revoohc@xxxxxxxxx> wrote:
>
> 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.
>
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l
- References:
- Converting from PostgreSQL to Oracle???
- From: Chris Hoover
Other related posts:
- » Converting from PostgreSQL to Oracle???
- » RE: Converting from PostgreSQL to Oracle???
- » Re: Converting from PostgreSQL to Oracle???
- Converting from PostgreSQL to Oracle???
- From: Chris Hoover