Re: Migrate postgres DB to oracle

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 07 Apr 2007 09:30:51 -0700
Message-ID: <1175963446.260827@bubbleator.drizzle.com>

bcochofel wrote:

> On Apr 6, 4:58 pm, DA Morgan <damor..._at_psoug.org> wrote:

>> bcochofel wrote:
>>> I need some help to migrate a postgres 7.4 DB to a oracle DB.
>>> Where can I found tools, SW or some kind of script to help me with
>>> this?
>>> Thanks,
>>> Bruno
>> Tools? Scripts?
>>
>> Are you talking only data or code?
>>
>> Is it your desire to make every table a heap table and every index
>> B*Tree or do you want something that will scale and perform?
>>
>> What version of Oracle?
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor..._at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org

> 
> I believe the version will be 10g R2.
> I want to migrate the postgres database to oracle. The entire tables,
> with triggers and all.
> I believe once this is done filling the oracle DB with the data will
> be easy.

Best practice in PostgreSQL is not best practice in Oracle. Again ... is it your desire to make every table a heap table and every index an ascending B*Tree index?

I would recommend that you, instead, generate the PostgreSQL DDL and then hand modify it for Oracle. Triggers will need to be recoded.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Sat Apr 07 2007 - 11:30:51 CDT