Coping big tables with image data

  • Need to make copy of couple tables (30-40 million records) with image data ASAP (Sql Server 2005 Ent Ed 64 bits). Using Sql Server Export/Import Wizard is pretty slowly (0.5 M/hour). Is there another way to do it faster? Probably bcp is OK (for me it does not matter- copy to table or file). But not sure what bcp options I should use. Thanks in advance

     

  • Read the following tips for faster BCP...

    Performance Tuning Tips for SQL Server BCP

    http://www.sql-server-performance.com/bcp.asp

     

    MohammedU
    Microsoft SQL Server MVP

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

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