Re: importing an Oracle database into Postgres

From: Matthew Hixson <hixson(at)poindextrose(dot)org>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: importing an Oracle database into Postgres
Date: 2005-12-29 00:11:44
Message-ID: CEC8CE15-CB4D-400B-A114-082434187244@poindextrose.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi David, it looks to me like this tool makes an external data source
appear to live within Postgres. What I want to do is dump an Oracle
database and replace it with Postgres. From that point on I don't
ever want to see Oracle again. Can your software be used to
accomplish that goal?
Thanks,
-M@

On Dec 28, 2005, at 1:10 PM, David Fetter wrote:

> On Wed, Dec 28, 2005 at 12:12:06PM -0800, Matthew Hixson wrote:
>> What's the best way to import an Oracle database into Postgres? I'm
>> using Oracle 8.1 and Postgres 8.1.1.
>
> DBI-Link. http://pgfoundry.org/projects/dbi-link/
>
> Let me know if you have questions or problems along the way :)
>
> Cheers,
> D
> --
> David Fetter david(at)fetter(dot)org http://fetter.org/
> phone: +1 415 235 3778
>
> Remember to vote!
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ted Byers 2005-12-29 00:14:41 Re: Final stored procedure question, for now anyway
Previous Message Trent Shipley 2005-12-29 00:03:07 Re: WAL logs multiplexing?