The attached PowerShell script should run just fine on any Windows machine having PowerShell to conveniently export photos from your Aeries PIC table.




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    jared@aeries.com