PostgreSQL Discussion - importing an Oracle database into Postgres

Author

importing an Oracle database into Postgres

Matthew Hixson

2005-12-28, 8:24 pm

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

Tom Lane

2005-12-28, 8:24 pm

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Jim C. Nasby

2005-12-28, 8:24 pm

http://archives.postgresql.org/pgsq...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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

David Fetter

2005-12-28, 8:24 pm

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

Matthew Hixson

2005-12-28, 8:24 pm

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:
>
> 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
>

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Matthew Hixson

2005-12-29, 3:24 am

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/pgsq...10/msg00311.php or
> contrib/oracle are probably your best bet.
>
> On Wed, Dec 28, 2005 at 12:12:06PM -0800, Matthew Hixson wrote:
>
> --
> 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
>

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Sponsored Links