Uploading Tiff Files into SQL Serevr 2005 Database

[lavadan]

Hi Folks,

I am a newbie to SQL Server. Please help me with this.

I have some tiff files. I have to upload them into sql server. How do i do this.
I will be getting the tiff files in a hardware and from there i have to load these images into sql server.

Is it a good idea to load the entire images into the database or just the pointers to the images. My manager said that they want to load the images into respective folders. But i think the database size is <100GB but i have approx 145million images (each image is approx 100-150KB). So i would get approx 750gb of images.

How should i handle this. Can you please suggest a way to do this.

[lavadan]

Can someone please guide loding tiff images into the sql database.

[debasisdas]

In your case ,you have two options to choose from.

1.Store the images in respective folders and store the path of the files in database.
2.Convert the file into binary format and store the actual image in database. For this you need to do some coding using some frontend tool.