How to efficiently copy million images from one table to another.

• shashi_1409

  SSCommitted

  Points: 1599

  More actions

  March 4, 2011 at 12:26 pm

  #235596

  I have a central database with million images and I need to copy these images into a table in another db on the same server, so can someone help me in designing a strategy for doing it efficiently. FYI there is no logic in this migration it is straight copy from one db to another.

  Which is faster Bluk copy, straight Insert into or is there any other strategy of doing it .

  thanks

  Shashi

• LutzM

  SSC Guru

  Points: 107049

  More actions

  March 4, 2011 at 12:45 pm

  #1294853

  duplicate post. no replies please.

  Discussion already started here

  ---

  
  Lutz
  A pessimist is an optimist with experience.

  How to get fast answers to your question[/url]
  How to post performance related questions[/url]
  Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]