I don't know that this is fully in-line with the subject of this thread, but, just I want share this in case it helps anyone:
A few years ago I made a blog post about using PowerShell to execute commands against Sql Server.
http://mattslay.com/sql-server-queries-using-powershell-lesson-1/
On 4/30/2020 10:16 AM, Stephen Russell wrote:
What SMO does for you is also available via powershell. Because I have the app written I don't work much in powershell for SQL Server analysis.
On Thu, Apr 30, 2020 at 2:58 AM Alan Bourke alanpbourke@fastmail.fm wrote:
Paul
There is no COM interface to SQL-SMO, so you would have to create a .NET assembly with a COM-callable wrapper exposing the functions you want I think. Or even just a .NET EXE which dumps any results to a text file that the vfp SIDE CAN READ.
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
[excessive quoting removed by server]