Post reply

Filestream to store Office documents?

  • June 26, 2014 at 1:57 am

    #309482

    I have been asked to look into using Filestream for centralising MS Office documents (mostly excel).

    Does it sound like a good idea?

    I am worried about the "user interface" aspect.

    I read that there are "this and that" APIs to read/write data to the filestream but surely one would need to write a specific interface to Word/Excel... which feels like far too hard :doze:

    I am a great admirer of SQL Server but is it the right tool for document management?

    We use SQL Server 2012 and have offices round the world with various internet connection quality.

    Our main aim is to stop the current "spreadsheet nightmare" so common with Excel.

    Thanks

    Eric

  • June 26, 2014 at 2:03 am

    #1724937

    To understand and Implement FileStream this might be very useful for you.

    The Art of SQL Server FILESTREAM by Jacob Sebastian and Sven Aelterman[/url]

  • June 26, 2014 at 2:05 am

    #1724938

    That was a quick answer!

    Thanks, I'll have a look.

    I also just came across Filetables which might help...

  • June 26, 2014 at 2:13 am

    #1724942

    FileTables extend the capabilities of the FILESTREAM feature of SQL Server. so if you want to work with FileTables you need to enable the FileStream for that SQL SERVER Instance.

  • June 26, 2014 at 2:16 am

    #1724943

    From what I have read so far, it seems to tick all the boxes...

    It seems both exciting (capabilities) and disappointing (too easy!)

  • June 26, 2014 at 3:33 am

    #1724973

    so what you have decided in the light exciting (capabilities) and disappointing (too easy!)?

  • June 26, 2014 at 4:15 am

    #1724991

    The exciting bit wins I think 😉

  • June 26, 2014 at 4:19 am

    #1724993

    🙂 .... Best of luck

  • June 27, 2014 at 8:55 am

    #1725478

    One other consideration though outside your stated requirements might be a Source Control tool such as Source Safe (Team Foundation Server) or SVN or even a local to your LAN set up of GIT.

  • June 27, 2014 at 9:02 am

    #1725486

    We already use TFS for our developments but it's another story to make end users use TFS...

    It might be "phase 2"...

Viewing 10 posts - 1 through 9 (of 9 total)

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