Post reply

extracting data from oracle to sql server 2008

  • 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.

  • 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?

  • October 24, 2011 at 5:45 am

    #1398622

    i ahve to stright copy the data for sigle time.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply