Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Data Transfer or Views from SQL Server to Oracle
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
> 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).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: orarup_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 - 08:53:40 CST