Обсуждение: importing an Oracle database into Postgres

What's the best way to import an Oracle database into Postgres?  I'm
using Oracle 8.1 and Postgres 8.1.1.
   Thanks,
    -M@

Matthew Hixson <hixson@poindextrose.org> writes:
> What's the best way to import an Oracle database into Postgres?  I'm
> using Oracle 8.1 and Postgres 8.1.1.

Look in contrib/oracle/ for some conversion tools.  I've never used 'em
and don't know if they're any good, but it's a starting point anyway.
Also I think you can find advice on some of the PG-related websites
such as techdocs.

            regards, tom lane

http://archives.postgresql.org/pgsql-advocacy/2005-10/msg00311.php or
contrib/oracle are probably your best bet.

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.
>   Thanks,
>    -M@
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

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@fetter.org http://fetter.org/
phone: +1 415 235 3778

Remember to vote!

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@fetter.org http://fetter.org/
> phone: +1 415 235 3778
>
> Remember to vote!
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

Thanks, Jim.  I've been playing with OraToPG.  So far I've found a
couple small problems with it that I'll probably solve with some
simple Perl, but overall its a very handy tool.
   I'll try to post a success story when I get this all straightened
out.
   Cheers,
    -M@

On Dec 28, 2005, at 12:38 PM, Jim C. Nasby wrote:

> http://archives.postgresql.org/pgsql-advocacy/2005-10/msg00311.php or
> contrib/oracle are probably your best bet.
>
> 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.
>>   Thanks,
>>    -M@
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 2: Don't 'kill -9' the postmaster
>>
>
> --
> Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
> Pervasive Software      http://pervasive.com    work: 512-231-6117
> vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461
>