RE: Oracle -> SQL Server

From: Christopher Spence <cspence_at_FuelSpot.com>
Date: Tue, 02 Oct 2001 12:52:23 -0700
Message-ID: <F001.0039F80E.20011002131031@fatcity.com>

It is for something which won't have a huge budget as the data is moving over to Oracle eventually, but for now we want access to it. I was thinking about just building a java/perl replication engine for now. It isn't a lot of data. But if there was something pre-packaged it would be nicer.

I think the transparent gateway was dropped, either way it is so expensive and out of the range for such a small project.

"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:55 PM
To: Multiple recipients of list ORACLE-L

Hi Christopher,

It can be done, Usually from third party software companies. For example, Check out:
http://www.datamirror.com/products/tserver/

Back in the day (1996), Oracle had a "Mainframe & Integration Technologies" group that handled such problems. You might want to contact Oracle and see if such a group still exists and if they can provide you with a solution.

Regards,
Satar

• Christopher Spence <cspence_at_FuelSpot.com> wrote:
  > 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
  >
  >
  >
  >
  >
  

  ---

Do You Yahoo!?
Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: satar naghshineh
  INET: satarnag_at_yahoo.com

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
--------------------------------------------------------------------
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).

Received on Tue Oct 02 2001 - 14:52:23 CDT