ORACLE to SQL Server

  • Hello,

    I Have all the files from a  oracle database (the oracle server is OFF), and i need this data in a new database in SQL Server.

     It´s possible import Oracle Tables to a database SQL Server ? .

    Thank you

  • Not from the files, no. They have to be on an active Oracle instance then you could transfer them.

  • You can use DTS to get the data or tables from Oracle. The Oracle server has to be ON and also, you need the Oracle client set up on the server where the SQL Server is.

  • Once you have the Oracle client setup on the Sql server, you could use OPENQUERY to do queries to the Oracle tables from SQL server.

  • If no connection to Oracle and all you have is offline Oracle dumpfile (which I suppose is in binary), you need first convert it to ASCII and then import to SQL Server. Your choices can be Oracle DUL that could be pretty expensive and it comes with Oracle support only. You can also try to import this dmp file back to Oracle and then extract into ascii. You can also use fastreader : http://www.wisdomforce.com. Fastreader is pretty fast while extracting Oracle data and it also creates loader for SQL server automatically

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply