SQL Server Management Objects
The SQLPS module exposes over 50 SQL Server-related cmdlets as of SQL Server 2014. This may seem more than a handful, but these cmdlets only cover a fraction of what you may want to do with SQL Server. There will be times when you may want to programmatically manage SQL Server, and SMO may be the most flexible way to do this.
SMO allows you to have programmatic access to SQL Server objects using languages such as VB.NET, C#, and PowerShell.
Note
To learn more about SMO classes and how to program specific tasks, visit the SMO documentation page from TechNet at http://msdn.microsoft.com/en-us/library/ms162169.aspx.
To install SMO, you need to run the SQL Server setup binary and select Client Tools SDK in the Features Selection ...
Get PowerShell for SQL Server Essentials now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
