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