sql server - Best way to move data from SQL to file system (FileStream?) -

sql server - Best way to move data from SQL to file system (FileStream?) -

at moment have sql server express instance database nearing 10gig limit. have table stores details activities, 1 column beingness "note" can 3000 characters long.

i take table , convert "note" column utilize file scheme frees database space. need column allow total text searching. i've poured on documents on filestreams can find still can't figure out best way this.

my main question how existing info (nvarchar(3000)) moved on new filestream column , allow total text searches work on this. i've read states have have column denotes file extension beingness used -- don't know how file info new field using specific file type. i'd fine using .txt type, if figure out how.

any ideas or best practices appreciated. i'm not hung on filestream, i'd take other recommendations well. company inexpensive purchase sql standard, i'd l

sql-server full-text-search sqlfilestream