January 25, 2017 at 9:59 am
Hi, I need some advise. I have inherited a database containing BLOB data spread over 3 tables and I need to merge these into one
Table 1 contains some master data - BlobID, created date - 200 Gb
Table 2 contains filestream blob data - BlobID, Contents - 300 Gb with 1.5 Tb filestream data
Table 3 contains smaller blob data - BlobID, Contents - 4 Tb
Ultimately I have been asked to replace these with 1 table - BlobID, created_date, TBLdata (Table3.Contents), FSData (Table2.Contents)
There's a few options I can think of, I could create a new table and merge them all, or add the existing Table 2 and 3 data into Table 1 as I would only need to migrate the contents data, or because of the size of table 3 I could look to migrate 1&2 into this, or even just create a view referencing all 3 tables (but the apps guys do not want to go down this route).
I've not sure what impact moving the Filestream contents would have with regards to the physical filestream data, would this 'link' be broken bearing in mind the actual filestream data will remain where it is.
So any advise or thoughts are welcome, how would you do it?
Thanks in advance
January 26, 2017 at 9:48 am
The filestream stuff is linked to the particular table/column. The on disk location would move if you create a new column, but if you move the data (insert, the delete), SQL moves it for you. Applications looking for Filestream connect to the server and get a handle for the particular column, so those need to know the data has moved, just like a T-SQL program needs to know which table/column to query.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply