Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: BLOBs from Oracle to MS Sql server

Re: BLOBs from Oracle to MS Sql server

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Thu, 12 Sep 2002 10:02:51 +0200
Message-ID: <alphoe$bp8$2@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.

--
Billy
Received on Thu Sep 12 2002 - 03:02:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US