Paul Randal takes us through some limitations on copying Filestream data between tables:
I was asked last week whether it’s possible to create a table with a FILESTREAM column and then populate that column by copying FILESTREAM files from another directory in the FILESTREAM data container.
The simple answer is no.
Paul explains why this isn’t possible and then gives you an alternative which does work.