Difference between Sqlcmd and Invoke-Sqlcmd

Question

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:

Santiago Squarzon · Accepted Answer · 2022-04-14 17:27:06Z

5

Invoke-SqlCmd is one of the PowerShell cmdlets from the SqlServer Module
sqlcmd is 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.

edited Apr 14, 2022 at 17:27

answered Mar 22, 2021 at 23:56

Santiago Squarzon

65.5k5 gold badges26 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Harry · Accepted Answer · 2024-09-26 13:44:20Z

0

-S is ambiguous in invoke-sqlcmd, use -ServerInstance when referencing your server/instance. SQLCMD uses a different set of parameters/options than Invoke-Sqlcmd and most abbreviations from sqlcmd cannot be used. Use the set as described in the Invoke-Sqlcmd reference from Microsoft: https://learn.microsoft.com/en-us/powershell/module/sqlserver/invoke-sqlcmd?view=sqlserver-ps

answered Sep 26, 2024 at 13:44

Harry

1

Collectives™ on Stack Overflow

Difference between Sqlcmd and Invoke-Sqlcmd

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related