SQL Images -> byte arrays

Question

So I am importing some images stored in SQL image columns, and I need to change them to Byte arrays since I store my images as varbinary(max) and recreate them. I would LOVE it if there was a program to do this, or a really easy way since I don't have a ton of time.

Any ideas out there?

Answer 1

The image data type in Sql Server is a varbinary field that is being discontinued in future versions.

I would bet that a tool like bcp handles the "conversion" automatically. I use quotes because its a type conversion and not a format conversion.

Answer 2

Have you looked into writing a quick script in PowerShell? It has access to the full .NET framework, so should be somewhat simple if you're using those technologies.

Of course it's not simple if you have to learn PowerShell in order to write the script, but learning's always good :)