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…@yahoo.com)
Date: Wed, 12 Jan 2005

"JAW" <jwilli…@aglresources.com> wrote in message
news:1105541798.727984.1048…@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

Replies

None

In response to

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