Re: migratation of database from oracle9i to postgreSQL8.0.3

From: Samer Abukhait <abukhait(at)gmail(dot)com>
To: zenith Das <zenith_das(at)yahoo(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: migratation of database from oracle9i to postgreSQL8.0.3
Date: 2005-11-10 17:21:15
Message-ID: 7d215b0c0511100921m3917af6cxd5237f7b55b8f200@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

There are some tools.. search about Ora2PG or so

One other way to go is to have the Oracle DB dumped out as text and
change/review the statements to suit your new structure and PG
differences
You definitely need mass changing tools with regular expressions.

On 11/9/05, zenith Das <zenith_das(at)yahoo(dot)com> wrote:
>
> Hi
> Can anyone help me out........
> How can i migrate database from oracle9i to postgreSQL8.0.3 where the table
> structure may differ in certain way...............
>
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Rod Taylor 2005-11-10 18:11:27 Re: time
Previous Message Jaime Casanova 2005-11-10 16:54:28 Re: [SQL] Como ejecutar una funcion insert en plpgsql....