Developing SQL-DMO Applications Using Visual Basic

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.

When using an OLE Automation controller, such as Microsoft Visual Basic 6.0, as a SQL Distributed Management Objects (SQL-DMO) application development tool, you should indicate that the application references the SQL-DMO object library. A specific OLE Automation controller defines which object library reference methods it supports.

For example, using the Visual Basic Project command References, you can indicate that SQL-DMO will be used by the project. When you indicate that a specific object library is referenced, Visual Basic can use OLE Automation to query the object library's type library for more information about objects contained in the library. Visual Basic uses type library data to both enrich the development experience and optimize the executable application.

When an OLE Automation controller can support an object library reference at the application or project level, it is recommended that you use the feature. Though the level of programming assistance varies from controller to controller, all OLE Automation controllers can use the object library reference to optimize the executable application. Making the controller aware of the SQL-DMO library at the earliest opportunity allows it to provide you with the most efficient SQL-DMO application.

For more information about support for add-in object libraries, see the OLE Automation controller documentation.

When developing a new management or replication application using the Microsoft .Net Framework, then use the SQL Server Management Objects (SMO) model instead of SQL-DMO.

Community Additions