RE: Hi,

  • From: "William Wagman" <wjwagman@xxxxxxxxxxx>
  • To: <DennisCutshall@xxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 16 Jul 2007 09:56:09 -0700

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@xxxxxxxxxxx
(530) 754-6208 

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dennis Cutshall
Sent: Monday, July 16, 2007 9:03 AM
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
  • References:
    • Hi,
      • From: Dennis Cutshall

Other related posts: