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