Re: Migrating data from SQL Server to Oracle

Giganews Newsgroups
Subject: Re: Migrating data from SQL Server to Oracle
Posted by:  Matthias Hoys (idmwarpzone_NOSPA…
Date: Wed, 12 Jan 2005

"JAW" <jwilli…> wrote in message
>I have done some testing of OMB (Oracle migration Workbench).
> Its good for big stuff but I just wish to migrate some tables.
> I could use SQL SERVERS DTS to write to Oracle tables and may well do
> it. Also, I could save the data to CSV and load via SQL Loader.
> However, I would like to crontol it from Oracle client. The Oracle
> Database is on UNIX and we don't have any UNIX ODBC drivers so
> Heterogenous services don't appear to be a solution.
> Is there a way via the Oracle client ODBC driver to configure it to
> talk to SQL SERVER which is ODBC compliant using a DB LINK?
> Seems like you should. You can do the opposite from SQL SERVER via a
> LINKED SERVER to Oracle.

I believe you need the "Transparant Gateway for MS SQL Server". More info
here :

HTH - Matthias



In response to

Migrating data from SQL Server to Oracle posted by JAW on 12 Jan 2005