2 Options: 1. Use MS Data Transport Service (DTS) and schedule transfer task 2. Write a Java program that will connect to both databases and transfer the data.
Raman. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, March 15, 2003 12:48 PM > 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: Raman Pujani 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).