>- My first thought is we'll eventually want to migrate the existing BLOB data out to the FileStream and work just from that column. Otherwise we'd have to search both the existing and new columns for stored files and UNION the results. If that's the case, any tips about the migration process? My understanding is no users have huge amounts of data in BLOBs but it could be multiple gigabytes (order of magnitude)


If HW capabilities are sufficient, correct a backup DB and only synch data changes done after backup creation. You have ample time to make that process error free.