RE: Hi,

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Mon, 16 Jul 2007 13:41:09 -0400
Message-ID: <D1DC33E67722D54A93F05F702C99E2A90117FA3B@usahm208.amer.corp.eds.com>

Here are a couple of notes on Generic Connectivity (also called Heterogeneous Services) that I have recorded from years past when I did this once: Oracle on AIX to SQL Server.  

See metalink notes 115098.1 Quick Start Guide: UNIX Generic Connectivity using ODBC and
115992.1 Generic Connectivity: ODBC to MS SQL Server for a start  

Note - I recorded these long ago so the document numbers/titles may have changed  

Oracle also sells the Oracle Transaction Gateway product as previously mentioned to perform a more full featured version of this same task.  

• Mark D Powell -- Phone (313) 592-5148

  ---

        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dennis Cutshall

	Sent: Monday, July 16, 2007 12:03 PM
	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

Received on Mon Jul 16 2007 - 12:41:09 CDT