All things Data Related....

On this site I will be posting entries related to Data platform and analytics that I learn and believe could be valuable learning to others who want insight from their data

Converting Existing table from BLOB to Filestream

Converting Existing table from BLOB to Filestream

  • Comments 1
  • Likes

1. Create FILESTREAM filegroup.

2. Add FILESTREAM column to table

3.   Choose one of:

a. Write an app to select data from the BLOB column and stream it into the FILESTREAM column

b. UPDATE <table> SET <filestream_column> = <blob column>;

4. Drop blob column

Note: Filestream data is in a separate filegroup, so you can selectively back up all the other filegroups.

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment