1.How to convert .MDF file consisting Table structures into Oracle!
Thanks & Regards,
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.
Life is a journey, not a destination!
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".
You cannect to any ODBC database directly from Oracle8i & Oracle9i using generic connectivity then simply do a:
CREATE TABLE my_table AS
Check this out:
Click Here to Expand Forum to Full Width