I am using latest version of Powershell core on Linux Ubuntu 16.04. I am trying to query a sql server database using powershell's invoke-sqlcmd cmdlet. (Yes I have installed the sqlserver module) I get an error which says that it cannot find the cmdlet. The command is there in windows powershell when I install the sqlserver module. Screenshot of the same
Does invoke-sqlcmd only work on Windows? If yes,is there another way I can achieve the same result in powershell core.
With Powershell core (6.2.3 at the time of this writing), you can install the sql server module like so:
Install-Module -Name SqlServer
and then you can call invoke-sqlcmd
If you want to know more about it: http://sqlvariant.com/2019/03/invoke-sqlcmd-is-now-available-cross-platform-in-the-sqlserver-module/
In PowerShell Core, the sqlserver module doesn't export any of the Invoke-* cmdlets. However, there are the Read-SQLTableData and Read-SQLViewData cmdlets that appear to work in a similar fashion if you've already created views on the server side.
Invoke-Command Invoke-Expression "sqlcmd -i ./dropDatabaseScript.sql"? Maybe you can put that as an answer? with more details?$files = "./*.sql";$command = 'sqlcmd -i $_';(also added dbname/user/psw and such)$expression = { Invoke-Expression $command };Resolve-Path $files | ForEach-Object { Invoke-Command -ScriptBlock $expression};