Existing tables with binaries to use filestream
- by user1098487
I've got a few tables for which I want to use filestream storage.
These tables already contain binary data and have rowguids. However at the time they were were created, the tables were not added to a filestream enabled filegroup.
What is the best way to have these tables use filestream at this point? Do I need to drop + recreate the tables and migrate the data? Is there an easier way?
The database already has filestream enabled and there are other tables which are using them.