importing data from oracle in less time.

• skanth

  Right there with Babe

  Points: 730

  More actions

  October 24, 2011 at 5:21 am

  #261868

  i have multiple oracle databases each withsize of 10gb.

  i have to move them to sql server 2008.

  let me know there is any other tools other than import and export wizard?

  i have to move the data (no need of indexing,data conversion) as fast as possible.

  let me kknow deatiled steps for that.

• jmadsen 98862

  SSC Eights!

  Points: 914

  More actions

  October 31, 2011 at 2:47 pm

  #1401314

  Try the SQL Server Migration Assistant for Oracle.

  http://www.microsoft.com/download/en/details.aspx?id=23945

  Works well for me.

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  October 31, 2011 at 2:53 pm

  #1401318

  Why do you need it to be as fast as possible?