From: | Ken Kinder <ken(at)kenkinder(dot)com> |
---|---|
To: | kumar iyer <skumariyer(at)hotmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: How do I port data into Postgres from other RDBMSs |
Date: | 2000-07-31 18:19:25 |
Message-ID: | Pine.LNX.3.96.1000731121718.1604A-100000@rage.x13.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | ryan | 2000-07-31 21:50:54 | Re: Installation problem |
Previous Message | Palle Girgensohn | 2000-07-31 18:09:28 | php/postgres persistent connections fail |