Data Transfer or Views from SQL Server to Oracle

From: Nikunj Gupta <good_dba_at_hotmail.com>
Date: Fri, 14 Mar 2003 23:18:47 -0800
Message-ID: <F001.0056B12D.20030314231847@fatcity.com>

Hello,

SQL Server in on Windows 2000 Box.
Oracle 8.1.7 is on Unix.

Is there any process by which data can be transferred from SQL SERVER to ORACLE directly.. something like views / snapshots. (Requirement is almost realtime data from SQL Server to Oracle)

I am initially not planning to dump the data from SQL Server (if possible) and then run loader etc..

I am still not on 9i... else maybe would could have tried to read external file directly after dump.

Thanks for any help or hint in this.

Nikunj
--

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

Author: Nikunj Gupta
  INET: good_dba_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 Sat Mar 15 2003 - 01:18:47 CST