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 Replaced by DataTable or DataSet system 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.

See Also

SQL Server Management Objects (SMO) Programming Guide