Insert image from file + Moving table with images

• michael.rosquist

  Ten Centuries

  Points: 1227

  More actions

  December 9, 2002 at 3:57 am

  #80544

  Hi,

  I have some thoughts about images in a table.

  1. I am inclined to do a stored procedure reading about 200 images from file in order to load a table with them. Advices?

  2. Is their another way to insert them?

  3. When I have the table populated I want to promote the the table to another server. Can I do this via a table backup/restore? Or is there easier/safer ways?

  /m

• Simon Sabin

  SSCrazy Eights

  Points: 8142

  More actions

  December 9, 2002 at 7:10 am

  #443735

  textcopy is the easiest way of inserting files.

  Once in SQL you can just copy the data between servers using insert into statements, or bcp and bulk insert

  Simon Sabin

  Co-author of SQL Server 2000 XML Distilled

  http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

  
  Simon Sabin
  SQL Server MVP
  
  http://sqlblogcasts.com/blogs/simons

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  December 9, 2002 at 7:12 am

  #443737

  For a different way to insert images, check out the Bulk Image Insert (BII) tool in the SQL2k Resource Kit. Like bcp, but for image columns.

  --

  Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

  http://www.sql.nu

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/