February 20, 2006 at 6:18 pm
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
February 21, 2006 at 7:18 am
Not from the files, no. They have to be on an active Oracle instance then you could transfer them.
February 22, 2006 at 5:28 am
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.
February 22, 2006 at 8:33 am
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.
February 23, 2006 at 11:30 pm
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