RE: Oracle -> SQL Server

From: Loughmiller, Greg <GLoughmiller_at_presolutions.com>
Date: Wed, 03 Oct 2001 08:08:07 -0700
Message-ID: <F001.003A0794.20011003074526@fatcity.com>

Or , =gulp= , you could use ASP/COM type objects too..... and use the infamous ODBC...

greg

-----Original Message-----
Sent: Wednesday, October 03, 2001 9:15 AM To: Multiple recipients of list ORACLE-L

Hmm, very interesting, that may be a good option.

"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: Wednesday, October 03, 2001 5:20 AM To: Multiple recipients of list ORACLE-L

Also, I believe there is JDBC for MSSQL now - previous there was some sort of JDBC-ODBC bridging thing, or something like that. So you could probably use Java stored procedures in Oracle, maybe with a PL/SQL wrapper, and get at your MSSQL data like that via stored procedure calls. Hmm.

-----Original Message-----
Sent: Tuesday, October 02, 2001 10:15 PM To: Multiple recipients of list ORACLE-L

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Guy Hammond
INET: guy.hammond_at_avt.co.uk

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: ListGuru_at_fatcity.com (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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Christopher Spence
INET: cspence_at_FuelSpot.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------