June 26, 2014 at 1:57 am
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
June 26, 2014 at 2:05 am
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
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
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
so what you have decided in the light exciting (capabilities) and disappointing (too easy!)?
June 26, 2014 at 4:15 am
The exciting bit wins I think 😉
June 26, 2014 at 4:19 am
🙂 .... Best of luck
June 27, 2014 at 8:55 am
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
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