Dave Mackey
Reputation: 4432
Export SQL Binary/BLOB Data?
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.
Upvotes: 1
Views: 1401
Answers (2)
Jack Knows Jack
Reputation: 344
Check the 2008 Books Online (search - OpenSqlFilestream) That API has great examples and may help you.
Upvotes: 2
Related Questions
- How can I export an entire SQL Server table to CSV, when the table contains an Image column?
- Export Blob From SQL Server and save it as a file
- Exporting binary file data (images) from SQL via a stored procedure
- How to export an ad-hoc SQLServer query blob data to a binary file
- Are there any utilities to extract binary data from SQL Server?
- How to "convert" a sql server Blob field to a "regular" file?
- Automating Export of MS SQL Table with a binary column (750,000 character length)
- SQL Server 2008 R2: Best way to export BLOB and other column data out to the file system
- Export blob from remote sql server and save to file on disk where sql server is located [C#]
- How can I export data from SQL Server?