Developing SQL-DMO Applications

This feature will be removed in the next version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

SQL Server Database Management Objects (SQL-DMO) has been removed from SQL Server 2008 R2 Express and the SQL Server 2008 R2 Feature Pack. SQL-DMO also does not support Database Engine features introduced after SQL Server 2000. We recommend that you modify applications that currently use this feature as soon as possible. If you must support SQL-DMO, install the Backward Compatibility Components from the SQL Server 2008 Feature Pack from the Microsoft Download Center. Do not use SQL-DMO in new development work; use SQL Server Management Objects (SMO) instead. You can obtain the SMO documentation by installing SQL Server 2008 R2 Books Online.

SQL Distributed Management Objects (SQL-DMO) is a collection of objects encapsulating Microsoft SQL Server database management and replication management.

SQL-DMO is a dual interface COM in-process server implemented as a dynamic-link library (DLL). When creating a SQL-DMO application, you can use any OLE Automation controller or COM client development platform using C or C++.

SQL-DMO automates:

  • Repetitive or commonly performed SQL Server administrative tasks.

  • SQL Server object creation and administration.

  • Creation and administration of SQL Server Agent jobs, alerts, and operators.

  • SQL Server replication installation and configuration.

SQL-DMO documentation covers the components of SQL-DMO, their use in developing applications, and SQL-DMO application construction. It also includes a detailed component reference.

Community Additions