Migrating data from SQL Server to Oracle

From: JAW <jwilliam_at_aglresources.com>
Date: 12 Jan 2005 06:56:38 -0800
Message-ID: <1105541798.727984.104890@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. Received on Wed Jan 12 2005 - 08:56:38 CST