O'Reilly logo

SQL Server 2014 with PowerShell v5 Cookbook by Donabel Santos

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Extracting binary data from SQL Server

In this recipe, we will extract the binary content from SQL Server and save it back to individual files in the filesystem.

Getting ready

For this recipe, we will use the table that we created in the previous recipe, Storing binary data in SQL Server, to extract files. Feel free to use your own tables that have the VARBINARY(MAX) columns; just ensure that you change the table name in the script.

In addition to our SampleBLOB table, we will create an empty table with a single VARBINARY(MAX) table. We will use this to facilitate the creation of a format file we need to export binary data out of SQL Server using bcp:

USE SampleDB GO IF OBJECT_ID('EmptyBLOB') IS NOT NULL DROP TABLE EmptyBLOB GO CREATE TABLE EmptyBLOB ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required