RE: Hi,

Oracle Heterogenous Services may be an option for you...depending on
your situation...
 
http://www.databasejournal.com/features/oracle/article.php/3442661

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dennis Cutshall
Sent: Monday, July 16, 2007 12:03 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Hi,


Hi,
 
We have a mixed environment of SQL Server and Oracle.  Because of this,
we now have a need to transfer table data between them.  This would be
on a continuing basis, probably on off-peak hours.  Our preference would
be to have the Oracle side drive the process, that is, Oracle pulling
table data from SQL Server.  Is anyone currently doing this, and would
pass on information on how it is done?  We know about Migration
Workbench, but that is more for a one-time conversion than a scheduled
nightly routine.  Any information or tips would be appreciated.
 
Dennis
 
Dennis Cutshall
Data Base Administrator
University of North Dakota ITSS
Phone: (701) 777-4109
Fax: (701)777-3978
E-Mail: DennisCutshall@xxxxxxxxxxxxxxxxxx

Other related posts: