Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006

    Unanswered: Oracle and MSSQL

    Hi All,

    I have 2 applications.

    The first is a commercial application, based on MSSQL database.

    The second, created with Oracle Developer Suite, is based on Oracle 10g database.

    Exist a method, in order to extract data from MSSQL tables and populate an Oracle table?

    If yes, how can perform this ?

    I hope in Your help.

    Thank You and Best Regards.

    Gaetano N.

  2. #2
    Join Date
    May 2004
    Dominican Republic
    They are two options I know you can use. If you're talking BIG (what I mean with this is if you're thinking of extracting a lot of data), then I would suggest you use DTS to extract the data from MSSQL to plain file and use either SQL*Loader or External Tables to load the data to Oracle. However, if you're going to extract bits of the data and want to have the ability to query the data directly from Oracle on a *real-time basis*, then you can use Oracle Heterogeneous Connectivity Services, using this, you have the ability to query MSSQL data directly from Oracle.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts