SQLPSX vs SQLPS

Jan 14, 2009 at 12:24 PM
Edited Jan 14, 2009 at 12:37 PM
Hi

I'm new to the shell and am trying to decide the 'best' way to use Powershell.

I could install SQLPSX, or I could install the SQL2008 feature pack components to install the SQLPS minishell. If I use the profile change provided by michiel on http://blogs.msdn.com/mwories/archive/2008/06/14/SQL2008_5F00_Powershell.aspx then I don't even need to use the minishell, I have all of the cmdlets etc available in the regular shell.

I guess I want to know if there are any advantantages to using SQLPSX over this method, or are the components provided by SQLPS a superset of SQLPSX?

***** EDIT: Sorry, just saw the link to your blog where you cover this nicely. I'll use SQLPSX.
*****

Thanks

Ewan


Coordinator
Jan 14, 2009 at 3:30 PM
No problem, here is the link to the blog entry you mentioned: http://chadwickmiller.spaces.live.com/blog/cns!EA42395138308430!188.entry

Keep in mind sqlps and sqlpsx are not necessarily mutually exclusive, you could load the SQLPSX functions in sqlps.exe OR make the profile changes suggested in the msdn blog. The one useful cmdlet Invoke-sqlcmd provided in Microsoft's sqlps.exe is nicely done. In addition Microsoft sqlps.exe does make it very easy to register servers in SQL Server Management Studio as described in this blog entry http://chadwickmiller.spaces.live.com/blog/cns!EA42395138308430!235.entry

I have not done extensive testing with sqlps and sqlpsx interaction, other than a previous discussion post in this forum. If you decide to go that route please report any issues in the discussion area.