Re: Postgres 7.4 to Oracle 10g Migration with BLOBs

[Jim Nasby <decibel(at)decibel(dot)org>]

On Oct 27, 2006, at 8:16 PM, Joshua D. Drake wrote:

> > I need to migrate a 60 GB Postgres 7.4 running on Linux to Oracle  
> > 10g running on Linux RedHat Enterprise Linux ES 4 update 4  
> > x86_64 .  I need help with a workable solution.
> > I tried pg_dump but it does not allow dumping blobs for migration  
> > to Oracle.
> > I tried a couple of tools but they do not work.
> > Oracle does not have a tool to do it for Postgres.
> >
> > I can only think of using ODBC driver but need help where the ODBC  
> > should be installed.
> >
> > Should it be installed on the Oracle server and should it be a  
> > Postgres ODBC?  Where can I down load it from?  I checked the  
> > postgres.org website but it was not clear whehter I needed to  
> > download the dll, mm, or msi!
>
> Sad to see you go... but dbi-link is likely your friend here.

You'll probably also want to convert the binary data to hex and then  
back again, though maybe dbi-link can actually handle binary data  
natively.
--
Jim Nasby                                            jim(at)nasby(dot)net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)