RE: Hi,

Greetings,  

We have also used Heterogeneous Gateway services between Oracle and DBII for some time now quite successfully although I have never attempted to configure it to allow Oracle to connect to SQL Server. I have configured Linked Servers in SQL Server to allow SQL Server to pull data form an Oracle database. With the exception of one little quirk that is pretty straightforward.  

Thanks.  

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dennis Cutshall Sent: Monday, July 16, 2007 9:03 AM
To: oracle-l_at_freelists.org
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_at_mail.und.nodak.edu

--
http://www.freelists.org/webpage/oracle-l