RE: SQL Server into Oracle

I ran into something similar to this. When we were migrating to Oracle from SQL Server7, our software engineers wanted to be able to access somewhat real-time data from the Oracle server. So, I created a DTS package on the SQL Server that exports the data to the Oracle server, saved the package to the repository, and told it to run every 4 hours. Once the engineers were done changing the application, I did one final export and shutdown the SQL server. We are now an all Oracle shop. :->

Todd

Todd W. McLain
Internet Operations Manager, Systems Engineer, DBA, & All-Around Good Guy KDD Okinawa Service Co., Ltd.
Okinawa, Japan

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of rcwomack_at_uswest.net
Sent: Thursday, July 27, 2000 8:44 AM
To: Multiple recipients of list ORACLE-L Subject: SQL Server into Oracle

Does anyone have any experience either grabbing data out of SQL Server and loading it into Oracle or know how SQL Server would capture data and then it retrieved and put into an Oracle Database?

Thanks,
Rodney

--
Author:
  INET: rcwomack_at_uswest.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).