|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
>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
HTH - Matthias
Migrating data from SQL Server to Oracle posted by JAW on 12 Jan 2005