SQL Server : Why do use SMO?

Question

我使用 SQL Server 已经有几年了。我听说过SMO，但我对此一无所知。使用它有什么好处？我应该在我的 SQL Server 项目(主要是数据仓库开发)中学习并开始使用 SMO 吗？为什么？

Answer 1

来自微软:

Overview (SMO)

SQL Server Management Objects (SMO) are objects designed for programmatic management of Microsoft SQL Server. You can use SMO to build customized SQL Server management applications. Although SQL Server Management Studio is a powerful and extensive application for managing SQL Server, there might be times when you would be better served by an SMO application.

For example, the user applications that control the SQL Server management tasks might have to be simplified to meet the needs of new users and to reduce training costs. You might have to create customized SQL Server databases, or create an application for creating and monitoring the efficiency of indexes. An SMO application might also be used to include third-party hardware or software seamlessly into the database management application.

The SMO object model extends and supersedes the Distributed Management Objects (SQL-DMO) object model. Compared to SQL-DMO, SMO increases performance, control, and ease of use. Most SQL-DMO functionality is included in SMO, and there are various new classes that support new features in SQL Server. The object model is intuitive and uses SQL-DMO terminology, where it is possible, to help transfer your skills.

您可以在此处下载 SMO:

Microsoft® SQL Server® 2008 R2 Feature Pack

开始编程:

Creating SMO Programs