Restore SQL database from Oracle dump

• vinod.km

  SSC Eights!

  Points: 971

  More actions

  July 8, 2009 at 11:32 pm

  #212191

  hi,

  Can I restore a dump taken in Oracle into SQL Server 2005? If yes, how? Any suggestion will be appreciable...

  Thanks

• SA-1

  SSCrazy Eights

  Points: 8113

  More actions

  July 9, 2009 at 5:55 am

  #1022286

  There maybe third party tools which may allow you to do that, but SQL Server doesn't let you directly restore an Oracle database back up.

  You could restore the database on a Oracle instance and use SSIS to import the structure and data.

• homebrew01

  SSC Guru

  Points: 55548

  More actions

  July 9, 2009 at 2:38 pm

  #1022686

  What format is the Oracle data ? Is it just 1 table in a flat file ? If so, maybe you could import it the same way you'd import a .csv