Re: [SQL] migratation of database from oracle9i to postgreSQL8.0.3

2005-11-10 Thread Samer Abukhait
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 <[EMAIL PROTECT

[SQL] migratation of database from oracle9i to postgreSQL8.0.3

2005-11-09 Thread zenith Das
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... Jaime Casanova <[EMAIL PROTECTED]> wrote: On 11/8/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]>wrote:> Hi> Looking the e-mail I remembered