Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Converting from PostgreSQL to Oracle???

Re: Converting from PostgreSQL to Oracle???

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 15 Jun 2005 11:26:31 -0700
Message-ID: <bf4638050615112628d56a9d@mail.gmail.com>


As long as you are doing a conversion, you should strongly consider going straight to 10g.
Jared

On 6/15/05, Chris Hoover <revoohc_at_gmail.com> 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
Received on Wed Jun 15 2005 - 14:31:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US