Post reply

Saving a word document in a Table

  • June 26, 2008 at 1:28 am

    #96050

    Hi

    How should i go about saving a word document in the database, basically i am creating a repository for all word documents in our department and I want to store them in my mssql database and be able to retrieve these doc's when i need to.

    Thanks

    Neel

  • June 26, 2008 at 9:03 am

    #834754

    Have you considered using Sharepoint for this?

  • June 26, 2008 at 9:06 am

    #834757

    You could save it as a binary data type field in the table.

    But you would be better off saving the file path for the document and simply store this in the database as a varchar field.

  • June 26, 2008 at 11:58 pm

    #835163

    how would sharepoint work with regards to this developing this application?

    Ok you say this i should write the file path to the database and write a front end application to access the file?

  • June 27, 2008 at 3:18 am

    #835221

    Neel Singh (6/26/2008)

    Ok you say this i should write the file path to the database and write a front end application to access the file?

    This is the way that I would do it, this would allow the file system to handle all the files rather than the db. Resulting in a samller and hopefully faster db.

    Put the files in a secure path and only allow your application to access it, also make sure you add all the files to your file back-up system.

    Have a look at this article for a bit more info, it is about images but most of the points are valid for other BLOBs;

    http://databases.aspfaq.com/database/should-i-store-images-in-the-database-or-the-filesystem.html

    Or you could get hold of a copy of SQL2008 and use the new FILESTREAM data type..

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply