Post reply

Heavy Table Copy Slow

  • November 28, 2013 at 6:56 am

    #300887

    We have an table of huge size with 19 million rows in it. Table has just two columns one of which is of type text.

    While exporting it to another sql server its taking around 10-12 hours using import/export wizard. Network speed is good enough.

    Please suggest ways to increase the speed.

    Destination database recovery model: Simple

    Foreign key constraints have been dropped on destination table already.

    Thanks

    MJ

  • November 28, 2013 at 7:03 am

    #1669683

    Save the package and edit it with BIDS.

    You can tweak the buffer settings and the BLOBTempStoragePath property to see if it gives additional gains.

    Data Flow Performance Features

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • November 28, 2013 at 12:08 pm

    #1669717

    Thanks Koen, any other way to speed up the process using bcp or any changes to import/export wizard..

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

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