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]