How to write to SQL Server using Powershell?

Question

When I try this script in Windows Powershell I'm getting The term 'Write-SqlTableData' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. What am I missing to get it to work? The script is taken directly from https://learn.microsoft.com/en-us/powershell/module/sqlserver/write-sqltabledata?view=sqlserver-ps

(Get-Process | Select-Object -Property Id,ProcessName,StartTime,UserProcessorTime,WorkingSet,Description) |
         Write-SqlTableData -ServerInstance "MyServerName" -DatabaseName "VA_Repository" -SchemaName "dbo" -TableName "TaskManagerDump" -Force

Answer 1

So did you install the SQL Server Powershell module?

Then again, you can do the normal ADO .Net stuff with SqlConnection and SqlCommand objects from PowerShell too.