Data Migration from MS SQL to Oracle

• deva21v

  SSC Veteran

  Points: 267

  More actions

  April 28, 2010 at 3:23 am

  #218272

  I need to migrate data from MS SQL to oracle . how to proceed?

  Thanks & Regards

  Deva

• shen-dest

  SSCrazy

  Points: 2498

  More actions

  April 28, 2010 at 3:34 am

  #1158724

  hi,

  you may use bcp to export MSSQL data and then use sqlldr to import.

  Regards,
  MShenel

• Mahesh Bote

  SSCrazy Eights

  Points: 9107

  More actions

  April 29, 2010 at 3:40 am

  #1159510

  [font="Verdana"]this article might help you bit.

  http://www.oracle.com/technology/obe/hol08/sqldev_migration/mssqlserver/migrate_microsoft_sqlserver_otn.htm

  --Mahesh

  [/font]

  MH-09-AM-8694