Link to home
Start Free TrialLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

VB.net and SQL Storing Images: Database or Folder

Hi

I have a client that uses a cloud SQL database that I set up for them. They need to store a number of images on a daily basis.
I was thinking of two ways to do this:
1. Insert each image into a varbinary field within  a SQL table
2. Store the images in a folder in their website and then just store a path to this image in a nvarchar field in SQL

Which is better? The second method feels right.
ASKER CERTIFIED SOLUTION
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Murray Brown

ASKER

Great. Thanks for validating that
Avatar of Éric Moreau
there is another option I really like. it is called FileTable: http://emoreau.com/Entries/Articles/2012/12/Microsoft-SQL-Server-2012-FileTable.aspx
Thanks Eric. Sorry I couldn't award points
no problem. it is just another more modern option I wanted to let you know
Appeciated. Thanks