SQL-DMO Mapping to SMO
SQL Distributed Management Objects (SQL-DMO) is no longer included in SQL Server 2012, SQL-DMO applications should be converted to use SQL Server Management Objects (SMO). The SMO object model is similar to SQL-DMO, so most SQL-DMO objects map to an object with the same name in SMO. However, some SQL-DMO objects were changed or dropped in the transition to SMO. This table lists the recommended action to take for SQL-DMO objects that were not converted directly to SMO.
|
SQL-DMO object |
Action in SMO |
|---|---|
|
View2 Object |
Moved to Microsoft.SqlServer.Management.Smo.Agent Namespace. |
|
AlertSystem Object |
Moved to Microsoft.SqlServer.Management.Smo.Agent Namespace. |
|
Application Object |
Removed. |
|
Backup Object and Backup2 Object |
Backup and BackupRestoreBase objects. |
|
BackupDevice Object |
BackupDevice objects |
|
BulkCopy Object and BulkCopy2 Object |
Removed and replaced by Transfer object. |
|
Category Object |
Moved to Microsoft.SqlServer.Management.Smo.Agent Namespace. Replace by AlertCategory, OperatorCategory, JobCategory objects. |
|
Check Object |
Check object |
|
Column Object and Column2 Object |
Column object. |
|
Configuration Object |
Configuration and ConfigurationBase objects. |
|
ConfigValue Object |
ConfigProperty object. |
|
Database Object and Database2 Object |
Database object. |
|
DatabaseRole Object and DatabaseRole2 Object |
DatabaseRole object. |
|
DBFile Object |
DataFile object. |
|
DBOption Object and DBOption2 Object |
Moved into the DatabaseOptions object. |
|
Default Object and Default2 Object |
Default object. |
|
DistributionArticle Object and DistributionArticle2 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. |
|
Distributor Object and Distributor2 Object |
Moved to the Microsoft.SqlServer.Replication namespace. |
|
DRIDefault Object |
Moved to ScriptingOptions object. |
|
FileGroup Object and FileGroup2 Object |
FileGroup object. |
|
FullTextCatalog Object and FullTextCatalog2 Object |
FullTextCatalog and FullTextIndex objects. |
|
Index Object and Index2 Object |
Index object |
|
IntegratedSecurity Object |
Functionality moved to ServerConnection object in Microsoft.SqlServer.Management.Common namespace. |
|
Job Object |
Job object. Moved to Microsoft.SqlServer.Management.Smo.Agent namespace. |
|
JobFilter Object |
JobFilter object. Moved to Microsoft.SqlServer.Management.Smo.Agent namespace. |
|
JobHistoryFilter Object |
JobHistoryFilter object. Moved to Microsoft.SqlServer.Management.Smo.Agent namespace. |
|
JobSchedule Object |
JobSchedule object. Moved to Microsoft.SqlServer.Management.Smo.Agent namespace. |
|
JobServer Object and JobServer2 Object |
JobServer object. Moved to Microsoft.SqlServer.Management.Smo.Agent namespace. |
|
JobStep Object |
JobStep object. Moved to Microsoft.SqlServer.Management.Smo.Agent namespace. |
|
Key Object |
ForeignKey and Index objects. |
|
LinkedServer Object and LinkedServer2 Object |
LinkedServer object. |
|
LinkedServerLogin Object |
LinkedServerLogin object. |
|
LogFile Object |
LogFile object. |
|
Login Object and Login2 Object |
Login object. |
|
MergeArticle Object and MergeArticle2 Object |
MergeArticle object. Moved to Microsoft.SqlServer.Replication namespace. |
|
MergeDynamicSnapshotJob Object |
Moved to Microsoft.SqlServer.Replication namespace. |
|
MergePublication Object and MergePublication2 Object |
MergePublication object. Moved to Microsoft.SqlServer.Replication namespace. |
|
MergePullSubscription Object and MergePullSubscription2 Object |
MergePullSubscription object. Moved to Microsoft.SqlServer.Replication namespace. |
|
MergeSubscription Object |
MergeSubscription object. Moved to Microsoft.SqlServer.Replication namespace. |
|
MergeSubsetFilter Object |
Moved to N:Microsoft.SqlServer.Replication namespace. |
|
NameList Object |
Removed. Alternative functionality in Scripter object. |
|
Operator Object |
Moved to Microsoft.SqlServer.Management.Smo.Agent namespace. |
|
Permission Object and Permission2 Object |
ServerPermission , DatabasePermission, ApplicationRole, and ObjectPermission objects. |
|
Property Object |
Property object. |
|
Publisher Object and Publisher2 Object |
ReplicationServer object. Moved to Microsoft.SqlServer.Replication namespace. |
|
QueryResults Object and QueryResults2 Object |
|
|
RegisteredServer Object |
Moved to Microsoft.SqlServer.Replication namespace. |
|
RegisteredSubscriber Object |
Moved to Microsoft.SqlServer.Replication namespace. |
|
Registry Object and Registry2 Object |
Removed. |
|
RemoteLogin Object |
ServerConnection object. Moved to Common namespace. |
|
RemoteServer Object and RemoteServer2 Object |
ServerConnection object. Moved to Microsoft.SqlServer.Management.Common namespace. |
|
Replication Object |
Moved to Microsoft.SqlServer.Replication namespace. |
|
ReplicationDatabase Object and ReplicationDatabase2 Object |
ReplicationDatabase object. Moved to Microsoft.SqlServer.Replication namespace. |
|
ReplicationSecurity Object |
ServerConnection object. Moved to Microsoft.SqlServer.Management.Common namespace. |
|
ReplicationStoredProcedure Object and ReplicationStoredProcedure2 Object |
ReplicationStoredProcedure object. Moved to Microsoft.SqlServer.Replication namespace. |
|
ReplicationTable Object and ReplicationTable2 Object |
ReplicationTable object. Moved to Microsoft.SqlServer.Replication namespace. |
|
Restore Object and Restore2 Object |
Restore and BackupRestoreBase objects. |
|
Rule Object and Rule2 Object |
Rule object |
|
Schedule Object |
Moved to Microsoft.SqlServer.Replication namespace. |
|
ServerGroup Object |
Removed. |
|
ServerRole Object |
ServerRole object. |
|
SQLObjectList Object |
SqlSmoObject array. |
|
SQLServer Object and SQLServer2 Object |
Server object. |
|
StoredProcedure Object and StoredProcedure2 Object |
StoredProcedure and StoredProcedureParameter objects |
|
Subscriber Object and Subscriber2 Object |
Moved to Microsoft.SqlServer.Replication namespace. |
|
SystemDatatype Object and SystemDataType2 Object |
DataType object. |
|
Table Object and Table2 Object |
Table object. |
|
TargetServer Object |
Moved to Microsoft.SqlServer.Management.Smo.Agent namespace. |
|
TargetServerGroup Object |
Moved to Microsoft.SqlServer.Management.Smo.Agent namespace. |
|
TransactionLog Object |
Functionality moved into the Database object. |
|
TransArticle Object and TransArticle2 Object |
TransArticle object. Moved to Microsoft.SqlServer.Replication namespace. |
|
Transfer Method and Transfer2 Object |
Transfer object. |
|
TransPublication Object and TransPublication2 Object |
TransPublication object. Moved to Microsoft.SqlServer.Replication namespace. |
|
TransPullSubscription Object and TransPullSubscription2 Object |
TransPullSubscription object. Moved to Microsoft.SqlServer.Replication namespace. |
|
Trigger Object and Trigger2 Object |
Trigger object. |
|
User Object and User2 Object |
User object. |
|
UserDefinedDatatype Object and UserDefinedDataType2 Object |
UserDefinedType object. |
|
UserDefinedFunction Object |
UserDefinedFunction and UserDefinedFunctionParameter objects. |
|
View Object and View2 Object |
View object. |
