There are many approaches.
1. dump the data to a sql script file , you may use -D option with pg_dump for max portability
2. use DBI
the exact process depends on the complexity of data , number of tables type of data etc.
i think you should migrate to a newer version of postgresql like 8.1.5 or
the upcoming 8.2 version instead of oracle.
regds
mallah.
On 10/31/06, SUBASH CHANDRA MOHAPATRA <subashchandramohapatra@xxxxxxxxx> wrote:
Hi All,Please help me how to migrate from the postgresql 7.4 to oracle 9i .Please let me know the process and the script alsoRegards,Subash
