March 15, 2020 at 3:19 am
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
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
Try Powershell. Something like:
March 16, 2020 at 5:29 pm
have you thought about using filestream ?
MVDBA
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy