Invoke-SqlCommand

Topics: Developer Forum, Project Management Forum, User Forum
Nov 26, 2008 at 7:28 PM
Hi,
I just installed version 1.1.1. But I must have missed a step because the 'SQL' cmdlets seem to be missing.

for example:
[591]PSH> invoke-sqlcommand
The term 'invoke-sqlcommand' is not recognized as a cmdlet, function, operable program, or script file. Verify the  term and try again.
At line:1 char:17 + invoke-sqlcommand <<<<

i  download the C# src code and found the InvokeSqlCommand.cs source and this code snippet:
namespace Pscx.Commands.Database
{
    [Cmdlet("Invoke", PscxNouns.SqlCommand,
        DefaultParameterSetName = "BuildConnectionString", SupportsShouldProcess=true)]
    public class InvokeSqlCommand : SqlCommandBase
    {

My assumption this was in the PSCX sanpin which is invoked in the profile.psq file as:
Add-PSSnapin Pscx

I will say i am new to PowerShell.
Why can't i execute the PSCX SQL cmdlets? Do i need to load the DLL (i.e. Pscx.dll) asemblies in the "C:\Program Files\PowerShell Community Extensions" folder?

thank you,
Mark
Developer
Nov 26, 2008 at 10:36 PM
Edited Nov 26, 2008 at 10:38 PM
As far as I know, there aren't any SQL cmdlets or functions included in any 1.x release ...

You'd have to build from source to get the SQL cmdlets that are in source control right now :D
Nov 26, 2008 at 10:58 PM
Jaykul,
OK, i see what you mean. I was looking at what I thought was the source code for the 1.1.1 version.
My mistake. Thanks for the information.
Mark