Nikunj, You can try something I did a long time ago, in Oracle 7.3; but it's also applicable now.
Create an ODBC datasource on the machine where the SQL Server resides to pint to the Oracle database. For the initial load, I suppose you can create a table in SQL Server as "select * from table_in_oracle". For the changes, put a trigger in each of the Oracle tables to capture the changes and write to a change_log table, similar to the replication related snapshot log table. Create a view that joins the main table and it's log table to show only the changed rows. From SQL Server side, simply read record-by-record from this view through the ODBC link and insert/update/delete as necessary. HTH. Arup Nanda ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, March 15, 2003 2:18 AM > 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: [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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda 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).
