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

Subscribe Post Reply

2023

lavadan

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

Similar topics

TIFF Files

by: Ken | last post by:

Are there any good code examples to display TIFF images from a SQL Server 2000 database on a web page? I have been searching the web and various newsgroups and have come up with very little. ...

ASP.NET

Tiff File Creation For Fax With FAXCOMLib

by: Will Arrowsmith | last post by:

Hi All, I am trying to create a .tiff file to fax using the windows fax service FAXCOMLib. I have created an array of images (bitmaps) and converted them to 1pbb format in order to allow...

Visual Basic .NET

uploading several docs at once

by: Chris | last post by:

I have a meetings section I'm developing on our intranet. Using PHP/MySQL. Meeting info and Meeting docs reside on 2 related tables in the db. Users may want to upload anywhere from 1 to 10 or...

PHP

EPS Tiff Preview

by: amit gupta | last post by:

Hello, I am using QuarkXPress on Macintosh to generate EPS Files with Tiff Preview embedded in it. I have written some C code to extract Tiff Preview from EPS files generated which works pretty...

C / C++

Tiff images

by: Sameer Gupta | last post by:

what are options for opening / handling tiff files in .Net framework ? which is the best library, namespace ? Please help Regards Sameer Gupta C# Designer & Developer Siemens UK

C# / C Sharp

TIFF/Image clean-up / compression component

by: Ben | last post by:

Hi We are looking for a component that offers that offers the below for Tiff files: Image clean-up (deskew, despeckle) Printing capabilities from VB The ability to add text to image, e.g....

Visual Basic .NET

Images TIFF on .aspx Web forms

by: =?Utf-8?B?R3VpbGxlcm1vIEppbWVuZXo=?= | last post by:

Hi.... Please help me with this case. I need to show an image .TIFF in a .aspx web page. The web site is developer on Visual Studio 2005. The image control no support this image format, that...

ASP.NET

221

Uploading files into a MySQL database using PHP

by: Atli | last post by:

You may be wondering why you would want to put your files “into” the database, rather than just onto the file-system. Well, most of the time, you wouldn’t. In situations where your PHP application...

PHP

Converting PDF to TIFF

by: Magnus Bergh | last post by:

I am looking for some good solution to convert PDF files to TIFF (which in turn will be stored in a database). I know there are a bunch of commercial options out there but most are to expensive or...

.NET Framework

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA