| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_mail.und.nodak.edu
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 16 2007 - 11:48:01 CDT
 |
 |