469,616 Members | 1,774 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,616 developers. It's quick & easy.

Uploading Tiff Files into SQL Serevr 2005 Database

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.
Dec 3 '07 #1
2 1916
Can someone please guide loding tiff images into the sql database.
Dec 4 '07 #2
debasisdas
8,127 Expert 4TB
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.
Dec 6 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Ken | last post: by
reply views Thread by Will Arrowsmith | last post: by
5 posts views Thread by Chris | last post: by
1 post views Thread by amit gupta | last post: by
5 posts views Thread by Sameer Gupta | last post: by
3 posts views Thread by =?Utf-8?B?R3VpbGxlcm1vIEppbWVuZXo=?= | last post: by
reply views Thread by Magnus Bergh | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.