Extracting data from a MySQL LONGBLOB

[WaterGypsy]

I've been googling without much luck on this.... I can't understand most of the discussion and when I do it seems to be pointing to different platforms pulling the data in and storing it themselves

I have a SQL database which is being decommissioned and I need to unload the data and transfer into sharepoint - most of that is covered... my problem is that there are attachments loaded into the database that I need to pull out and store on a network drive. The attachments could be in Word, Excel, pdf etc etc , but they are all stored in the database as LONGBLOB binary fields... is there a simple solution to this problem (I'm an absolute beginner with SQL)

 

[Kyle123]

Have a look at the ADODB.Stream object, it takes binary data and writes it to disk

 

[mole999]

perhaps a small consultancy fee to someone who is a) competent, b) qualified c) insured & also have a backup dumped to a clean drive. That has to be worth the investment unless the total loss is acceptable SharePoint 2010: Import Data from SQL Server into a List using PowerShell - TechNet Articles - United States (English) - TechNet Wiki