Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2005
    Posts
    36

    Unanswered: Saving documents in SQL2005

    Hi,

    I was wondering if I can save documents e.g. pdf, word, excel or anyother format in sql2005.
    If yes what datatype should I use and what would be the best way to go about it.

    Thanks in advance

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    You could

    But you would be better of just storing the file name and path of a file server in the database and storing the documents on the file server

    Look up image datatype in BOL
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Apr 2005
    Posts
    36
    Thanks for the quick reply. So your suggestion is saving the docs on file server and the path and file name in sql server which is what I am doing at this time... but I thought saving docs in sql itself would have been a better option for security and ease of use etc.

    Can you please give me some reasons why would it be better if I not save files on sql e.g. lots of load etc. so I will give that explaination to my boss here .
    Thanks

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    From what I understand it'a a maint nightmare, plus you have to get the data out chunks, it's not a simple operation, and then you have to put them all back together

    You have BOL?

    http://msdn2.microsoft.com/en-us/library/ms130214.aspx
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Apr 2005
    Posts
    36
    Oh thank you for the link there for BOL .
    And I would go with your suggestion for using file server instead of SQL for saving files now it does makes sense.

    Thank you very much for the help.

Posting Permissions

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