question

joe.btfsplk47 avatar image
joe.btfsplk47 asked

Migrating from IMAGE to FILESTREAM

I have inherited a SQL2012 database with several rather large tables filled with IMAGE data. I need to reduce the size of the database and would like to replace IMAGE columns with FILESTREAM columns. I have enabled FILESTREAM and created FILESTREAM filegroup. In TEST table I have 104K images taking up 10 GB of space. I created the required ROWQUID column and a FILESTREAM column. Then I run UPDATE TEST_TABLE SET NewFilestreamColumn = Old_Image_Column It works in that the images are moved to my the file system. BUT now I still have a 10GB column in the database and 10 GB of images in the file system. How do I move the images AND reduce the database space used?
sql-server-2012filestream
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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

0 Answers

·

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.