Installing SQL Server Management Objects
SQL Server Management Objects (SMO) was introduced with SQL Server 2005 to allow SQL Server to be accessed and managed programmatically. SMO can be used in any .NET language, including C#, VB.NET, and PowerShell. Since SQL Server does not ship with many cmdlets, SMO is the key to automating most SQL Server tasks. SMO is also backwards compatible with previous versions of SQL Server, extending support all the way to SQL Server 2000.
SMO comprises two distinct classes: the Instance
classes and the Utility
classes.
The Instance
classes are the SQL Server objects. Properties of objects such as the server, databases, and tables can be accessed and managed using the instance classes.
The Utility
classes are helper ...
Get SQL Server 2014 with PowerShell v5 Cookbook 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.