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

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

Other related posts: