Murray Brown
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
there is another option I really like. it is called FileTable: http://emoreau.com/Entries/Articles/2012/12/Microsoft-SQL-Server-2012-FileTable.aspx
ASKER
Thanks Eric. Sorry I couldn't award points
no problem. it is just another more modern option I wanted to let you know
ASKER
Appeciated. Thanks
ASKER