I'm migrating a images DB of a system
I know the structure of the data tables and all type of data in it
How can I learn about the STORAGE of IMAGES? In sql Server
Where can I found information about that?
I need to know something about that topic
usually, whats the way for image’s storage ?
I prefer to store the UNC pathname in a NVARCHAR or VARCHAR column rather than store the BLOB in an IMAGE column. File systems are optimized for handling files, SQL Server is optimized for handling data... Let each do what it does best.
The general idea that I use is to store the images in some central repository (usually a single folder exposed as a network share). These images can be saved and retrieved using code (such as a script on an ASP page), which is usually much more efficient than pulling the same data from a SQL Server. This approach also makes it much easier to scale upward, since you can then add web servers as needed to your system without putting significantly more load on your database server (which often becomes a weak point if you use the database server to store your images too).