question

FranciscoE avatar image
FranciscoE 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.
filemoveblob
6 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

How much data are we talking about here anyway?
0 Likes 0 ·
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
0 Likes 0 ·
How much data? How many GB, how fast is it growing?
0 Likes 0 ·
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
0 Likes 0 ·
So that's, what, 100GB per DB? Or are some databases just a few gig, and some others in the Terabyte range?
0 Likes 0 ·
Show more comments

1 Answer

· Write an Answer
ThomasRushton avatar image
ThomasRushton answered
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.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.