If you want to build only one interface, dumping the data to a flat
ASCII-file is probably the best bet. Oracle has (from 9i onwards) an
external table facility, which allows you to treat an Ascii file as an
ordinary table.
One other option is to use the Heterogeneous Gateway, which allows
Oracle to connect to Sqlserver, and other databases. HG comes in an OLE
DB flavour and in an ODBC flavour.
Finally you could use the Oracle ODBC driver to connect your source
database to Oracle.
--
Sybrand Bakker
Senior Oracle DBA
Received on Fri Sep 16 2005 - 07:19:24 CDT
