Re: Migrating data from SQL Server to Oracle

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Wed, 12 Jan 2005 23:31:53 +0100
Message-ID: <41e5a55a$0$313$ba620e4c@news.skynet.be>

"JAW" <jwilliam_at_aglresources.com> wrote in message news:1105541798.727984.104890_at_z14g2000cwz.googlegroups.com...
>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 : http://www.oracle.com/technology/products/gateways/index.html.

HTH - Matthias Received on Wed Jan 12 2005 - 16:31:53 CST