SQL Server and Working with Images.

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL Server and Working with Images.

Author

Topic

tarekahf
Starting Member

2 Posts

Posted - 2011-01-18 : 08:16:53

I am refering to this article:

http://www.sqlteam.com/article/images-and-sql-server

I have a project that requires to collect data from the users including images (Staff Photos). This is the form I will use:

https://docs.google.com/viewer?a=v&pid=explorer&chrome=true&srcid=0B97clwYte2SHNDlhMzhkMDMtNzIyOC00M2U5LWFhMTYtNmViMjZmM2JmMTIz&hl=en&authkey=CN-G0E4

My manager requested me to Store the submitted images inside a field in SQL Server.

Every Staff will have average 4-6 dependants, and there are total of 1500 staff.

I read in serveral places that it is not recmmended to store the images inside a field in SQL Server Table, because it is not natural way of doing things.

My manager told me that this is correct in the past, by now, in SQL Server 2008 and above, there should be no problem.

I need to know what you think ?

Is it OK to store Images in SQL Server ?

Or should we stroe them in a local folder, and store only a link to the file in SQL Server ?

Tarek.

Sachin.Nand

2937 Posts

Posted - 2011-01-18 : 08:22:39

If you are using SQL 2008 check the Filestream Object.

PBUH

tarekahf
Starting Member

2 Posts

Posted - 2011-01-18 : 08:33:36

PBUH,

Thanks for your reply.

As a mater of fact, I've see several examples in the net about how to store images in SQL Server.

My question is actually what is your recommendation ?

Which method is better ?

Tarek.

Sachin.Nand

2937 Posts

Posted - 2011-01-22 : 02:16:17

I will go for Filestream object .

PBUH

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources