0

I am very new to SQL Server 2008 and question may look very basic to gurus.

Following in the problem universe.

  1. I have a huge (600 GB size) SQL Server 2008 table that stores pdf files in a column of type Image
  2. Need is to download all the images from database table to my desktop (not on to the server).
  3. I can't run C#, ASP.NET etc in the environment and has to rely on SQL Server Management Studio for the job (I see a option called power shell but not sure how to use it)

Table looks like following

Table name : Attachments

Columns :

FileID (PK, int, not null)  
Owner (int, null)   
file_name (varchar(50), null)   
file_type (varchar(50), null)   
file_size (int, null)   
file_date (datetime, null)  
file_BIN (image, null)
user2026061
  • 1
  • 2

1 Answers1

1

This answer provides the following Simple Talk article with instruction and information on how to extract this data. Unfortunately, there is no cut and dried method for natively converting this data because of the hurdles in storing this kind of data within a database table.

For more discussion on this practice and the issues surrounding it, I suggest you read this answer.

Community
  • 1
Mike Fal
  • 12,418
  • 2
  • 47
  • 60