Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2006
    Posts
    8

    Unanswered: SQL storage images

    greetings!!!

    Help me please!

    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 ?
    Last edited by Vicco; 02-28-06 at 16:56.

  2. #2
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276
    Hi Vicco,
    do you read the book online (the doc of sql)?
    BLOB in Book online:
    - Managing ntext, text, and image Data
    - ntext, text, and image
    - Using text and image Data

  3. #3
    Join Date
    Feb 2006
    Posts
    8

    Thanks achiola

    Thanks for your help Achiola

    I'm a new SQL Server user.

  4. #4
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276
    perfect, in the book online an techCenter of microsoft, you can find in http://www.microsoft.com/technet/pro...l/default.mspx

    slds
    abel.

  5. #5
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276
    rewriting: (my spanglish is very bad).

    perfect, in the book online or in the techCenter of microsoft, you can find in http://www.microsoft.com/technet/pro...l/default.mspx

    slds
    abel.

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    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).

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •