importing an Oracle database into Postgres

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:

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: