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: [EMAIL PROTECTED] 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: [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).