Upgrading

Upgrading a SQL-DMO application is not possible. The application must be rewritten using SMO classes. See SQL-DMO Mapping to SMO.

SQL Server 2000 and SQL Server 7.0 Support

The following SMO namespaces are not supported by earlier versions of SQL Server:

• Microsoft.SqlServer.Management.NotificationServices

• Microsoft.SqlServer.Management.Smo.Broker

• Microsoft.SqlServer.Management.Smo.Mail

• Microsoft.SqlServer.Management.Smo.RegisteredServer

• Microsoft.SqlServer.Management.Smo.Wmi

• Microsoft.SqlServer.Management.Trace

Partial support for earlier versions is available for Microsoft.SqlServer.Management.Smo.Agent and Microsoft.SqlServer.Management.Smo namespaces.

The classes in the Microsoft.SqlServer.Management.Smo namespace provide support for SQL Server 2000 and SQL Server 7.0 with the following exceptions in:

Class	Support for Earlier Versions
Certificate	No
Column	Partial
Credential	No
DatabaseDdlTrigger	No
DatabaseDdlTriggerEvent	No
DatabaseDdlTriggerEventSet	No
DatabaseEvent	No
DatabaseEvents	No
DatabaseEventSet	No
DatabaseMirroringPayload	No
Endpoint	No
EndpointPayload	No
EndpointProtocol	No
HttpProtocol	No
IPExceptionObject	No
MasterKey	No
NumberedStoredProcedure	Partial
NumberedStoredProcedureParameter	Partial
ObjectEvent	No
ObjectEventSet	No
Parameter	Paritial
PartitionFunction	No
PartitionFunctionEvents	No
PartitionFunctionParameter	No
PartitionScheme	No
PartitionSchemeEvents	No
PartitionSchemeParameter	No
Payload	No
Protocol	No
ProtocolIPException	No
Schema	No
SchemaEvents	No
ServerDdlTrigger	No
ServerDdlTriggerEvent	No
ServerDdlTriggerEventSet	No
ServerEvent	No
ServerEventSet	No
ServerTraceEvent	No
ServerTraceEventSet	No
ServiceBrokerPayload	No
ServiceMasterKey	No
ServiceQueueEvent	No
ServiceQueueEventSet	No
SoapMethodObject	No
SoapPayload	No
SoapPayloadMethod	No
SqlAssembly	No
SqlAssemblyEvent	No
SqlAssemblyEvents	No

See Also

Reference

Discontinued Database Engine Functionality in SQL Server 2008 R2

Concepts

SQL-DMO Mapping to SMO