How to move non structured data from local DB in SQL 2005 and transfer it to a diferente repository ?
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.
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.