Importing Blobs from a MySQL Database and Export Them

  • Abhishek Chaturvedi

    SSC Eights!

    Points: 970

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

  • s.youngman

    Valued Member

    Points: 54

    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

    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: 7099

    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.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply