Post reply

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

  • 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

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

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

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