| Lists: | pgsql-admin |
|---|
| From: | "kumar iyer" <skumariyer(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | How do I port data into Postgres from other RDBMSs |
| Date: | 2000-07-29 05:10:28 |
| Message-ID: | LAW-F215s6i5frtIw2o0000156b@hotmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
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: | 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 |
| 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
>