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 1
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?
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,
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.
> Thank
Matthew Hixson <[EMAIL PROTECTED]> 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.
A
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
