CODEWITHSUNDEEP
sql-server
Alaa Jabre
Alaa Jabre

Reputation: 1893

Best way to store images in sql server on a network server

I'm developing an application that needs to store large images and about 100 image a day about 3 people work on the same application DB (desktop application connected to same db)

any one of theme can view , edit, delete other work which means all of theme can access certain image at once

now the question is what is the best way to store images this big (currently I'm storing the images in a table but i know this eventually will suck)

I'm using sql server 2008

Upvotes: 0

Views: 460

Answers (1)

D'Arcy Rittich
D'Arcy Rittich

Reputation: 171511

You could use the new in v2008 FILESTREAM data type to store your images. This is a hybrid approach that means the data can be queried from SQL, but the data itself is stored in the filesystem rather than in the database.

Upvotes: 4

Related Questions