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. 

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