extracting data from oracle to sql server 2008

• skanth

  Right there with Babe

  Points: 730

  More actions

  October 24, 2011 at 5:20 am

  #390681

  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.

• rgtft

  Hall of Fame

  Points: 3518

  More actions

  October 24, 2011 at 5:42 am

  #1398621

  SQL Server Integration Services (SSIS) would be my tool of choice. The import/export wizard is just a specialized package (and limited) package that uses the SSIS engine. What data transformation do you need? Or is this a straight copy?

• skanth

  Right there with Babe

  Points: 730

  More actions

  October 24, 2011 at 5:45 am

  #1398622

  i ahve to stright copy the data for sigle time.