Re: [GENERAL] Migrating Oracle to PostgreSQL

From: Leif Jensen <leif(at)crysberg(dot)dk>
To: Makarov Gera x8521 <GMakarov(at)Citipower(dot)com(dot)au>
Cc: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>, "'pgsql-docs(at)postgresql(dot)org'" <pgsql-docs(at)postgresql(dot)org>, "'pgsql-ports(at)postgresql(dot)org'" <pgsql-ports(at)postgresql(dot)org>, "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>, "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: [GENERAL] Migrating Oracle to PostgreSQL
Date: 2002-04-18 13:21:46
Message-ID: Pine.LNX.4.21.0204181519240.6352-100000@samba.crysberg.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-docs pgsql-general pgsql-ports pgsql-sql


Hi,

Have a look at www.openacs.org. This is an open project for converting
the ACS (Oracle based) web system into an open source system based on
PostgreSQL (in the first place). I believe there is a migration document
somewhere in there.

Greetings,

Leif

On Thu, 18 Apr 2002, Makarov Gera x8521 wrote:

> Hi there,
>
> Has anyone migrated Oracle database to Postgres? If yes, could you please
> help me - what
> are the steps involved, complications you faced, any other info you think is
> appropriate.
> Thanks in advance.
>
> Regards,
>
> Gera Makarov
> Oracle DBA
> CitiPower Pty
>
>
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
>
> This email message has been swept for the presence of
> computer viruses
>
> CitiPower Pty. ACN 064 651 056
> **********************************************************************
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Karel Zak 2002-04-18 13:26:13 Re: Migrating Oracle to PostgreSQL
Previous Message Morten Sickel 2002-04-18 12:49:39 Re: problem in module Pg with Apache, Perl and SSL

Browse pgsql-docs by date

  From Date Subject
Next Message Karel Zak 2002-04-18 13:26:13 Re: Migrating Oracle to PostgreSQL
Previous Message Makarov Gera x8521 2002-04-18 05:24:32 Migrating Oracle to PostgreSQL

Browse pgsql-general by date

  From Date Subject
Next Message Karel Zak 2002-04-18 13:26:13 Re: Migrating Oracle to PostgreSQL
Previous Message Tycho Fruru 2002-04-18 12:53:26 Re: Postgresql installation problem

Browse pgsql-ports by date

  From Date Subject
Next Message Karel Zak 2002-04-18 13:26:13 Re: Migrating Oracle to PostgreSQL
Previous Message Makarov Gera x8521 2002-04-18 05:24:32 Migrating Oracle to PostgreSQL

Browse pgsql-sql by date

  From Date Subject
Next Message Karel Zak 2002-04-18 13:26:13 Re: Migrating Oracle to PostgreSQL
Previous Message Karel Zak 2002-04-18 12:41:34 Re: now() does not change within a transaction