DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: convert .MDF files to Oracle!

Hybrid View

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    Hi all!

    Query:

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

    Thanks & Regards,

    Amit.

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    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
    anandkl

  4. #4
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    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
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width