Importing Blobs from a MySQL Database and Export Them

• Abhishek Chaturvedi

  SSC Eights!

  Points: 970

  More actions

  July 11, 2016 at 12:03 am

  #400389

  Comments posted to this topic are about the item Importing Blobs from a MySQL Database and Export Them

• s.youngman

  Valued Member

  Points: 55

  More actions

  July 11, 2016 at 2:02 am

  #1889347

  Nice article,

  I did something similar a few years ago, though I did it slightly different.

  I used a linked server to migrate the data into SQL, then used PowerShell with SMO to export the blobs.

• Abhishek Chaturvedi

  SSC Eights!

  Points: 970

  More actions

  July 11, 2016 at 7:15 am

  #1889401

  Thanks for taking the time to read the article.

  I can see linked servers doing the job as well. But I used SSIS so I could filter out the errored records in a separate data set and process them separately.

  Cheers.

• Ray Mond

  SSCertifiable

  Points: 7159

  More actions

  July 11, 2016 at 9:40 am

  #1889452

  SQL Image Viewer can export blobs from MySQL and most other popular database servers, and even files embedded in OLE Object fields.

  SQL BAK Explorer - read SQL Server backup file details without SQL Server.
  Supports backup files created with SQL Server 2005 up to SQL Server 2017.