Re: Some Data from SServer to Oracle - Options ?

From: Michael Austin <maustin_at_firstdbasource.com>
Date: Mon, 13 Nov 2006 03:23:41 GMT
Message-ID: <1zR5h.13334$B31.7359@newssvr27.news.prodigy.net>

klabu wrote:

> "DA Morgan"
>

>>How much data? Both companies offer solutions for this. From my
>>experience the Oracle one is more likely to work with newer versions
>>of Oracle.

>
>
> Just a SELECT.....like < 1000 records
>
> I read this
> http://www.oracle.com/technology/products/oracle9i/datasheets/gateways/gateway_rel2_ds.html
> Transparent Gateway is not an option (10gR2/Linux)

You could install the TG4MSSQL on the windows box and then use a database link to pull it.

>
> Generic Connectivity - not sure if I read it correctly - restriction :
> Installed on the same machine as the database
>
>

This would use ODBC-type services.

-- 
Michael Austin.

Received on Sun Nov 12 2006 - 21:23:41 CST