Re: Hi,

Re: Hi, You didn’t mention what platform your Oracle database is on. If you’re on Windows you can easily do this through a database link with Heterogeneous Services. Just set up an ODBC DSN to SQL Server, then create a file for that data source in %ORACLE_HOME%\hs\admin. Finally, add the service to your listener.ora and tnsnames.ora and create a database link that uses the entry in your tnsnames file. There are examples of how to set up these admin files in the hs/admin directory.

I haven’t tried this on Linux or Unix, so I can’t speak to how easy or hard it is on those platforms.

On 7/16/07 11:02 AM, Dennis Cutshall wrote:

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@mail.und.nodak.edu

---------------
Jason Heinrich
Oracle Database Administrator
Pensacola Christian College
(850) 478-8496 x2509
jheinrich@pcci.edu

Re: Hi,

Jason Heinrich

2007-07-16