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
Concepts
Other Resources
Discontinued Database Engine Functionality in SQL Server 2005
Upgrading to SQL Server 2005