Ah yes = the age old question... You can either write small scripts (I
like Python) that connect to both and do manual SQL, try to do a dump from
Oracle (I think TOAD does a nice one) and load it in a text editor to
clean it up for Postgres, or get a third party tool.
I hear good things about Data Junction, and it may connect with PostgreSQL
if you have PG ODBC running.
I'm a little partial to the Python scripting. :)
--
Ken Kinder
www.kenkinder.com
On Sat, 29 Jul 2000, kumar iyer wrote:
> My name is Sreekumar.G.Iyer and I'm working as a software engineer
> with Wellspring Networks Pvt. Ltd., Pune, India.
>
> My question regarding postgresql is as follows :
> How do I populate my tables in postgresql with data stored in tables
> on other RDBMSs viz. Oracle or MS-Access.
>
> I would be very grateful if someone could help me with my problem.
>
> Thanking you.
>
>
> Sreekumar Iyer
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>