Post reply

export stored images to disk

  • March 15, 2020 at 3:19 am

    #3734487

    My movie collection has all dvd covers of every film stored inside the sql server database .

    Worked ok until the database grew over thousands of films and the retrieval of the data

    became a nightmare. So I decided to get them out of there to a separate folder where I

    would store them as *.jpeg files and load them by my application on after scroll event.

    Saving each and every film cover to a file is pretty long process to do manually.

    Is there a way I could export images stored in a sql server 2014 database (table name FILMS)

    to a file folder on disc ?

    Each film has an unique identifier (DVD_ID) so I tought I could batch export all images and

    save them to disk as a files so that each file is named as the DVD_ID of each film.

    Example: If the movie has DVD_ID as A001 the file stored would be called A001.jpeg.

    Any way to do this ?

  • March 16, 2020 at 4:10 am

    #3734588

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • March 16, 2020 at 3:10 pm

    #3734752

    Try Powershell. Something like:

    https://social.technet.microsoft.com/wiki/contents/articles/890.export-sql-server-blob-data-with-powershell.aspx

     

  • March 16, 2020 at 5:29 pm

    #3734799

    have you thought about using filestream ?

    MVDBA

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

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