The attached PowerShell script should run just fine on any Windows machine having PowerShell to conveniently export photos from your Aeries PIC table.
NOTE: Revised on 2025-04-11 to omit extra period sometimes stored in PIC.XT so the file being exported will not have a double period before the extension. File names now exported with lower case extension to be more uniform and pretty. ~Jared
Uses ADO.NET connection method which avoids needing to load SQL PowerShell extensions (SQLPS) making it more portable.
Credits:
Original ADO.NET export method by Olaf Helper https://social.technet.microsoft.com/wiki/contents/articles/890.export-sql-server-blob-data-with-powershell.aspx
*Changed to SQL authentication method since people will use this against a SQL Server outside of their domain if hosted.
*Added prompting for all pertinent parameters to make it work for anyone with different options.
*Used folder selection method Jason Doss found for us which may be from this article. http://stackoverflow.com/questions/11412617/get-a-folder-path-from-the-explorer-menu-to-a-powershell-variable
~Jared Kuszewski