Wednesday, November 08, 2006

Speaking of SMO, SMO for PowerShell - PowerSMO

Dan Sullivan - PowerSMO!

"Last year I wrote a blog article about using what was then called MSH with SQL Server Management Objects http://pluralsight.com/blogs/dan/archive/2005/12/29/17703.aspx. MSH is now called PowerShell and mixing some SMO with it makes PowerSMO!

SMO is a set of object models for SQL Server. With PowerSMO! you can manipulate those object models from the command line or with a script. The two object models probably of most interest to SQL Server developers and DBA’s are the Server and ManagedComputer object models and that’s what this article is going to use them to show how to use PowerSMO!.

..."

Nice...

Related Past Post XRef:
Execute T-SQL Scripts (with GO's) Programmatically with SMO (or DMO)

No comments: