SQL-DMO Mapping to SMO
Several SQL Distributed Management Objects (SQL-DMO) properties have been moved or removed in the transition to SQL Server Management Objects (SMO). This table explains what has happened to DMO properties that have not been converted to SMO directly.
SQL-DMO object | Action in SMO |
---|---|
Moved to Microsoft.SqlServer.Management.Smo.Agent Namespace. |
|
Moved to Microsoft.SqlServer.Management.Smo.Agent Namespace. |
|
Removed. |
|
Backup and BackupRestoreBase objects. |
|
BackupDevice objects |
|
Removed and replaced by Transfer object. |
|
Moved to Microsoft.SqlServer.Management.Smo.Agent Namespace. Replace by AlertCategory, OperatorCategory, JobCategory objects. |
|
Check object |
|
Column object. |
|
Configuration and ConfigurationBase objects. |
|
ConfigProperty object. |
|
Database object. |
|
DatabaseRole object. |
|
DataFile object. |
|
Moved into the DatabaseOptions object. |
|
Default object. |
|
Moved to Microsoft.SqlServer.Replication namespace. |
|
DistributionDatabase Object and DistributionDatabase2 Object |
Moved to Microsoft.SqlServer.Replication namespace. |
DistributionPublication Object and DistributionPublication2 Object |
Moved to Microsoft.SqlServer.Replication namespace. |
DistributionSubscription Object and DistributionSubscription2 Object |
Moved to Microsoft.SqlServer.Replication namespace. |
Moved to the Microsoft.SqlServer.Replication namespace. |
|
Moved to ScriptingOptions object. |
|
FileGroup object. |
|
FullTextCatalog and FullTextIndex objects. |
|
Index object |
|
IntegratedSecurity Object object |
Functionality moved to ServerConnection object in Microsoft.SqlServer.Management.Common namespace. |
Job object. Moved to Microsoft.SqlServer.Management.Smo.Agent namespace. |
|
JobFilter object. Moved to Microsoft.SqlServer.Management.Smo.Agent namespace. |
|
JobHistoryFilter object. Moved to Microsoft.SqlServer.Management.Smo.Agent namespace. |
|
JobSchedule object. Moved to Microsoft.SqlServer.Management.Smo.Agent namespace. |
|
JobServer object. Moved to Microsoft.SqlServer.Management.Smo.Agent namespace. |
|
JobStep object. Moved to Microsoft.SqlServer.Management.Smo.Agent namespace. |
|
ForeignKey and Index objects. |
|
LinkedServer object. |
|
LinkedServerLogin object. |
|
LogFile object. |
|
Login object. |
|
MergeArticle object. Moved to Microsoft.SqlServer.Replication namespace. |
|
Moved to Microsoft.SqlServer.Replication namespace. |
|
MergePublication object. Moved to Microsoft.SqlServer.Replication namespace. |
|
MergePullSubscription Object and MergePullSubscription2 Object |
MergePullSubscription object. Moved to Microsoft.SqlServer.Replication namespace. |
MergeSubscription object. Moved to Microsoft.SqlServer.Replication namespace. |
|
Moved to N:Microsoft.SqlServer.Replication namespace. |
|
Removed. Alternative functionality in Scripter object. |
|
Moved to Microsoft.SqlServer.Management.Smo.Agent namespace. |
|
ServerPermission, DatabasePermission, ApplicationRole, and ObjectPermission objects. |
|
Property object. |
|
ReplicationServer object. Moved to Microsoft.SqlServer.Replication namespace. |
|
Moved to Microsoft.SqlServer.Replication namespace. |
|
Moved to Microsoft.SqlServer.Replication namespace. |
|
Removed. |
|
ServerConnection object. Moved to Common namespace. |
|
ServerConnection object. Moved to Microsoft.SqlServer.Management.Common namespace. |
|
Moved to Microsoft.SqlServer.Replication namespace. |
|
ReplicationDatabase object. Moved to Microsoft.SqlServer.Replication namespace. |
|
ServerConnection object. Moved to Microsoft.SqlServer.Management.Common namespace. |
|
ReplicationStoredProcedure Object and ReplicationStoredProcedure2 Object |
ReplicationStoredProcedure object. Moved to Microsoft.SqlServer.Replication namespace. |
ReplicationTable object. Moved to Microsoft.SqlServer.Replication namespace. |
|
Restore and BackupRestoreBase objects. |
|
Rule object |
|
Moved to Microsoft.SqlServer.Replication namespace. |
|
Removed. |
|
ServerRole object. |
|
SqlSmoObject array. |
|
Server object. |
|
StoredProcedure and StoredProcedureParameter objects |
|
Moved to Microsoft.SqlServer.Replication namespace. |
|
DataType object. |
|
Table object. |
|
Moved to Microsoft.SqlServer.Management.Smo.Agent namespace. |
|
Moved to Microsoft.SqlServer.Management.Smo.Agent namespace. |
|
Functionality moved into the Database object. |
|
TransArticle object. Moved to Microsoft.SqlServer.Replication namespace. |
|
Transfer object. |
|
TransPublication object. Moved to Microsoft.SqlServer.Replication namespace. |
|
TransPullSubscription Object and TransPullSubscription2 Object |
TransPullSubscription object. Moved to Microsoft.SqlServer.Replication namespace. |
Trigger object. |
|
User object. |
|
UserDefinedType object. |
|
UserDefinedFunction and UserDefinedFunctionParameter objects. |
|
View object. |