Chapter 27. Automating SQL Server Management using SMO
Allen White
When managing Microsoft SQL Server, there is rarely just one best way to accomplish any given task. Server Management Objects (SMO) and its sisters, Replication Management Objects (RMO) and Analysis Management Objects (AMO), are object libraries that enable you to manage SQL Server to best fit your needs.
Microsoft provides excellent tools to manage SQL Server, but they may not always fit the skill set of your administrative team. For example, your operations team may be more inclined to script all management tasks (not a bad idea and the graphical tools provided don’t necessarily lend themselves to automation). SMO, introduced with SQL Server 2005, was built using the .NET ...
Get SQL Server MVP Deep Dives 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.
