The "non structured data" in local DB represents 85% of overall information (namely in documents format ("BLOB")) and the local and central problems with storage reached the limit. The application over SQL 2005 local is a legacy solution actually in VB6. I didn't find in SQL Server 2005 any "way" to "retire" these data (for example "file stream") to a an alternative structure.
asked May 20, 2013 at 10:06 AM in Default
In general terms, it sounds as though you want / need to replace your SQL Server-based document repository with something that's a bit more like a traditional document management system.
Long time ago, I used to work on systems like this, but that was a while ago, so I'll be interested to hear what the rest of the #AskSSC gang makes of it.
answered May 20, 2013 at 10:40 AM