Re: BLOBs from Oracle to MS Sql server

"Billy Verreynne" <vslabs_at_onwe.co.za> wrote in message news:alphoe$bp8$2_at_ctb-nnrp2.saix.net...
> Zbrk wrote:
>
> > Is it possible to transfer blobs from Oracle database to MS Sql server
> > database using generic connectivity.
>
> Yes - depending of course what you mean by 'generic connectivity'.
>
> The easiest way I can think of is to write a client app that does this -
> pushing and pulling the blobs. I would write it in Delphi (a few minutes
> effort and likely less than 10 lines of code) and run it on the same
> platform as SQL-Server to prevent doubling the network traffic with the
> pull from SQL-Server and push to Oracle.
>

I'd use DTS (so it can be scheduled etc etc). isn't there an Oracle feature/option/product called generic connectivity though?

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************