Results 1 to 4 of 4

Thread: Archiving

  1. #1
    Join Date
    Aug 2005
    Posts
    12

    Unanswered: Archiving

    Hi All,
    I'm building an archiving applicaition for my small organization, but I have many file types such as videos, photos, texts, pdfs.... and some huge file sizes of about 500 MB.
    My questions are:
    1. Somefriend told me that there is a hardware compression device which can compress allready compressed videos and JPEGs. Is it correct? If so, where can I surf to find such devices?
    2. Which datatype have I to use with SQL Server 2000 to handle all the different file types and sizes?

    Thanks very much
    Haytham

  2. #2
    Join Date
    Aug 2005
    Posts
    12

    Help!!

    Any answer there?

  3. #3
    Join Date
    Nov 2002
    Posts
    272
    1. I'd be surprised if such a thing exists. Ask your friend to be more specific.

    2. I'd guess binary or varbinary. I have no experience storing binaries in sql-server though.

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Store raw datafiles as text or image datatypes.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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