Difference Between Sqlcmd and Invoke-Sqlcmd
I Am Trying to Learn Sqlcmd Utility in Powershell to Run Sql Queries, Specifically for Database Administration. Using Version 15.0.1300.359 Nt but I Got...
I am trying to learn Sqlcmd utility in PowerShell to run SQL queries, specifically for database administration.
Using Version 15.0.1300.359 NT
But I got confused, what is the difference between Sqlcmd and Invoke-Sqlcmd?
Why is it this command works:
Invoke-Sqlcmd -ServerInstance myinstance -Database AdventureWorks2017 "select top 3 * from [Person].[BusinessEntity]"
And this one does not work:
Invoke-Sqlcmd -S myinstance -d AdventureWorks2017 "select top 3 * from [Person].[BusinessEntity]"
By querying help I can clearly see that I should be able using all those variables:
1 Answer
Invoke-SqlCmdis one of the PowerShell cmdlets from theSqlServerModulesqlcmdis a Microsoft Utility
If you're working on PowerShell scripting, I would recommend the use of the Module whenever possible. Invoke-SqlCmd will output objects, which are definitely easier to manipulate.
Alexander Ross has covered the video game industry for a decade, writing deep dives on game design, esports tournaments, VR developments, and gaming culture.
