Recently a software application we utilize upgraded from ASP to ASP.NET. In the process they abandoned the old web-based product and rewrote the entire UI, using new DB tables. The old DB tables still exist in the database and contain legacy files in binary or blob formats. I'm wondering if there is an easy way to export all these legacy files from the database to the filesystem (NTFS)? Then we could delete these old unused tables and save a few GB of space in the DB backups, etc.
+2
A:
Check the 2008 Books Online (search - OpenSqlFilestream) That API has great examples and may help you.
Jack Knows Jack
2010-06-03 16:02:28