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