importing dump backup database from oracle to sql server

• praspras42

  SSC Veteran

  Points: 296

  More actions

  March 27, 2012 at 10:46 pm

  #253856

  Hi all

  Can anyone tell me how to import dump backup database from oracle

  to sql server.is it possible??if yes then please somebody tell me the step by step instructions with example please.

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  March 28, 2012 at 10:38 am

  #1465810

  If by dump, you mean an export (.dmp), then no. You'll have to import it into an Oracle database first then use SSIS to import directly from Oracle.

  Greg