IMAGE field type

• Tomputor

  SSC Enthusiast

  Points: 159

  More actions

  March 4, 2003 at 12:30 am

  #101397

  Hi,

  Is there an easy way to copy binary data (Image field type) from a table to a table on another Sqlserver (no conection).

  Normaly we use a tool that generates insert statements (like ObjectScriptr) that contains the data.

  I get a long string for an Image field, but it gets broken up when inserting (I think it has something to do with binary data 13 (CR))

  The way I do it, is to make a Backup of the database containing the table and restoring it localy.

  Thanks,

  Tom

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  March 4, 2003 at 6:38 am

  #450216

  BCP should work.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  Connect with me on LinkedIn

• Tomputor

  SSC Enthusiast

  Points: 159

  More actions

  March 4, 2003 at 7:23 am

  #450217

  Thanks Andy,

  Had to look up BCP, I had never used it before

  Tom

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  March 4, 2003 at 8:34 am

  #450227

  DTS usually suffices, but for raw speed BCP usually the fastest, and definitely handy for situations like the one you have. Other option would be to copy image and pkey to a new table in a new db on the source server (using DTS), then detach, copy db to dest server, attach, then DTS again.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  Connect with me on LinkedIn

• Tomputor

  SSC Enthusiast

  Points: 159

  More actions

  March 4, 2003 at 8:37 am

  #450229

  BCP works fine,

  Thanks a lot

  Tom