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. :)
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
In response to
pgsql-admin by date
|Next:||From: ryan||Date: 2000-07-31 21:50:54|
|Subject: Re: Installation problem|
|Previous:||From: Palle Girgensohn||Date: 2000-07-31 18:09:28|
|Subject: php/postgres persistent connections fail|