Migrating data from SQL Server to Oracle

Giganews Newsgroups
Subject: Migrating data from SQL Server to Oracle
Posted by:  JAW (jwilli…@aglresources.com)
Date: 12 Jan 2005

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.

Replies