Обсуждение: 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 >