Post reply

Oracle .dmp to SQL Server 2005

  • August 28, 2007 at 10:39 am

    #176459

    I am trying to import an Oracle .dmp database into SQL Server 2005, what would you suggest as the fastest and easiest way to do this? DTS/SSIS doesn't have an instant solution and the script I tried to use gave me an error...

    Msg 3241, Level 16, State 0, Line 1

    The media family on device '' is incorrectly formed. SQL Server cannot process this media family.

    Msg 3013, Level 16, State 1, Line 1

    RESTORE DATABASE is terminating abnormally.

    I would like a GUI based way to do this if at all possible. Thanks

    -Kyle

  • August 28, 2007 at 11:58 am

    #729875

    The structure of an Oralce DMP file is incompatible with SQL Server. You will need either the data exported to CSV or TAB files for importing or have an Oracle server to connect to an import the data from it (restore the DMP file to another Oracle server if you cannot access the original).

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply