Networks

Ask something
Question Locked

How to Import SQL Server 2000 data to Oracle 10g

0 helpful
5 replies

by terry.bobo 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'm trying to import data from a SQL Server 2000 Data to Oracle. I have Oracle 10g and TOAD installed, but not SQL Server 2000, as I only have the SQL Server backup and .mdf file and log file. How can I read/view the contents of the backup or .mdf file wihout having SQL Server 2000. I'm trying not to go back to the location of the SQL Server and extract all of the Tables as comma delimeted files. Looking for another option to this.

5 replies

by tony hopkinson

Anymore than you could import from an Oracle DB without Oracle.
You can use Toad or DTS etc to do the transfer, but both servers have to be accessible from the machine doing it.

Otherwise it's back to a common file format, csv, xml etc, which the DBMS files most definitely are not.

by brooklynpennypincher

Have you tried Oracle Migration Work Bench ?

I suspect you'll still have to pull the data via an ODBC connection, but at least you won't have to go table by table.

This discussion is closed to new replies.