As you may know, we’ve created a SQL Server 2008 provider for PowerShell. With this very cool feature you’re able to navigate SQL Server and it’s objects as easily as you could the file system on your hard drive. You also have access to all of the properties and methods that we have in Server Management Objects, or SMO.
What you may not know is that when we bundle PowerShell with SQL Server, you’ll find it with a new name – SQLPS.EXE. It’s just the same PowerShell program, with our libraries already loaded up for you.
But what if you already have PowerShell, and you want to use the SQL Server libraries? No worries. I was speaking with a friend of mine, Rob Farley, an MVP from Australia. He’s published a set of steps to “snap in” the SQL Server 2008 provider to your existing PowerShell program. You can check out those steps here: http://msmvps.com/blogs/robfarley/archive/2008/03/04/sql-server-2008-powershell-snapin.aspx