asked
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.
The documents stored in local SQL Server 2005 are used by a court application, essential to manage daily law court acivities. The non structured data are joint with structured data but as to heavy (85% vs 15%) are surcharging the application performance and delaying the "backups". We don't want to move the data to a document management solution. Instead, we want to move the non structured data out of local DB to enhance performance and storage process, but the local application needs continuous that data (documents). What architectural scenarios (in SQL 2005) may be available to store the documents data ? Thanks
330 Local DB (1 by court) 220 Physical 110 Virtualized 31 Tb of total data, with 27 Tb related to non structured data Average Growth- 620 Mb/Month FE
So that's, what, 100GB per DB? Or are some databases just a few gig, and some others in the Terabyte range?
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.
14 People are following this question.
