Re: Postgresql To Oracle9i - Mailing list pgsql-sql

From Jan Wieck
Subject Re: Postgresql To Oracle9i
Date
Msg-id 3E4156CF.DEF6878B@Yahoo.com
Whole thread Raw
In response to Postgresql To Oracle9i  ("Atul Pedgaonkar" <atul@imcindia.net>)
List pgsql-sql
Atul Pedgaonkar wrote:
> 
> Hello,
> 
>         Atul here From india.Anyone who knows how to mirgrate the data from
> postgresql7.2 to Oracle9i.Please give the idea or methood to transfer the
> data.

Use pg_dump to create separate schema and data (as INSERT statements)
dumps. Edit the schema so that Oracle is happy with it and run the two
SQL scripts.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


pgsql-sql by date:

Previous
From: george young
Date:
Subject: design question: status table+log table, indexes, triggers
Next
From: Jan Wieck
Date:
Subject: Re: automatic time/user stamp - rule or trigger?