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

Other Resources

SQL Server Management Objects (SMO) Programmnig Guide