If you want to run SQL commands from your PowerShell terminal you can do so by simply installing the SQLServer module with the command below: You will be prompted to install from an untrusted source. Type “A” to accept and install the module. Once it is complete you can see…
If you want to run SQL commands from your PowerShell terminal you can do so by simply installing the SQLServer module with the command below:
Install-Module sqlserver
You will be prompted to install from an untrusted source. Type “A” to accept and install the module.
Once it is complete you can see all the new commands you have available to you by running the following command:
Get-Command -Module SQLServer
And that’s it! Now you can run commands like Invoke-SqlCMD!