Re: migrating from Oracle to PostgreSQL

Lists: pgsql-general
From: Faizol Halim <faizol_h(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: migrating from Oracle to PostgreSQL
Date: 2003-05-16 13:28:40
Message-ID: 20030516132840.55020.qmail@web10004.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Hi all,
any pointers about articles that I should read to
facilitate a migration from oracle to postgresl?
Actually, it's not gonna be a full migration, but
rather to have an automated task (possibly via cron
everyday at midnite) to get data from several database
on oracle (which reside on a sun server) to a dual-x86
based system.

TIA.

regards,
Faizol

__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com


From: Richard Huxton <dev(at)archonet(dot)com>
To: Faizol Halim <faizol_h(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: migrating from Oracle to PostgreSQL
Date: 2003-05-16 15:48:08
Message-ID: 200305161648.08260.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

On Friday 16 May 2003 2:28 pm, Faizol Halim wrote:
> Hi all,
> any pointers about articles that I should read to
> facilitate a migration from oracle to postgresl?
> Actually, it's not gonna be a full migration, but
> rather to have an automated task (possibly via cron
> everyday at midnite) to get data from several database
> on oracle (which reside on a sun server) to a dual-x86
> based system.

Worth checking out the "converting" section of http://techdocs.postgresql.org/

--
Richard Huxton