I was thinking that same thing as the easiest way as I know transparent
isn't cheap and there probably isn't an easy way.
I was going to use Perl/Java to make something if there isn't any other way
like the OPENQUERY option in SQL Server to look at oracle tables.
"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275
Fuelspot
73 Princeton Street
North, Chelmsford 01863
-----Original Message-----
Sent: Tuesday, October 02, 2001 4:14 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Oh geez, here I go again.
This is trivial with Perl, DBD::Oracle and DBD::ODBC.
Whether it is useful to you depends on a number of things.
* can you use an Oracl copy of the SQL server data?
* does the data always need to be fresh?
* how fresh?
* how big is it?
Since it's temporary, this may work for you.
Jared
Christopher
Spence To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
<cspence@FuelS cc:
pot.com> Subject: Oracle -> SQL Server
Sent by:
[EMAIL PROTECTED]
om
10/02/01 11:40
AM
Please respond
to ORACLE-L
I know there is a way in SQL server to query oracle tables, is there a way
to do the reverse?
I am looking at trying to create access from an Oracle DB to SQL Server
data until we convert the SQL server database.
Anyone have any ideas on this, I searched technet (ms/oracle) and metalink,
as well as some search engines without luck.
"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275
Fuelspot
73 Princeton Street
North, Chelmsford 01863
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christopher Spence
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
