Re: Data Transfer or Views from SQL Server to Oracle

Nikunj Gupta wrote:
>
> 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

Nikunj,

   You have various options, coming at different prices. I *think* that Oracle provides a gateway to Sybase/SQL Server; the reverse is also true. Some 3rd party products offer (so to speak) various replication capabilities between Oracle and SQL Server. Sybase's own Replication Server is a good product, which may help you achieve snapshot-like replication. If you feel like doing it yourself, perhaps you can combine the new Net8 APIs and Open Server and build your own bridge. Otherwise the object option, through views mapping PL/SQL tables, can provide an interesting solution if you handle volumes which can hold in memory (fully or incrementally). I have used this to do about the same you want to do with data from an iPlanet LDAP server (I have written a paper with Robert Goral to explain the basics of the technique, it has been published on the Online Edition of Oracle Magazine, search their archives).
  Lots of solutions indeed,which depend on how much you are ready to fork, volumes, and what you are ready to code.

-- 
HTH,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.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).