CAVEAT: This was all done by an external party before I started with the company.
We have a sharepoint list (source) that is exported to a sql server database table (destination) in order to perform reporting (reporting services). The reason this was done was to for the manager to interpret the column naming in a more friendly way than that of the sharepoint naming convention (int2, int4, float5 etc in source) to rego,driver name,rental cost etc in destination.
Basically the list is made up of all of the vehicles in our service department and their current allocation to jobs.
The current process is completed using a sql server agent job.
MY QUESTION IS THIS:
There is now a need to export any attachments (all pictures of said vehicles) from the source to sql server destination.
Ho do I copy an item from the sharepoint list to the sql server table?
Where do I find the list attachments in the sharepoint database?
Any guidance would be appreciated,