convert .MDF files to Oracle!

[amitstora]

Hi all!

Query:

1.How to convert .MDF file consisting Table structures into Oracle!

Thanks & Regards,

Amit.

[sambavan]

AFIK, there is no interface in oracle that could open the .MDF file. But one thought would be to install the Oracle transparent gateway for SQL-server and then try to access the data through that.


Sam

[anandkl]

You can also export from sql server into oracle using microsoft odbc for oracle whild doing the export and query from oracle to see the tables...
Makes sure you rename your tables because sql server exports table with double quotes like "table_name".

cheese
anandkl

[TimHall]

You cannect to any ODBC database directly from Oracle8i & Oracle9i using generic connectivity then simply do a:

CREATE TABLE my_table AS
SELECT *
FROM my_table@mdbdatabase;

Check this out:

http://www.oracle-base.com/Articles/...ectivity9i.asp

Cheers