Partilhar via


Mapeamento de SQL-DMO para SMO

Várias propriedades do SQL-DMO (SQL Distributed Management Objects) foram movidas ou removidas na transição para o SMO (SQL Server Management Objects). Esta tabela explica o que aconteceu com as propriedades do DMO que não foram convertidas diretamente para o SMO.

Objeto do SQL-DMO

Ação no SMO

Alert Object

Movido para o namespace Microsoft.SqlServer.Management.Smo.Agent.

AlertSystem Object

Movido para o namespace Microsoft.SqlServer.Management.Smo.Agent.

Application Object

Removido.

Backup Object e Backup2 Object

Objetos Backup e BackupRestoreBase.

BackupDevice Object

Objetos BackupDevice

BulkCopy Object e BulkCopy2 Object

Removido e substituído pelo objeto Transfer.

Category Object

Movido para o namespace Microsoft.SqlServer.Management.Smo.Agent. Substituir pelos objetos AlertCategory, OperatorCategory e JobCategory.

Check Object

Objeto Check.

Column Object e Column2 Object

Objeto Column.

Configuration Object

Objetos Configuration e ConfigurationBase.

ConfigValue Object

Objeto ConfigProperty.

Database Object e Database2 Object

Objeto Database.

DatabaseRole Object e DatabaseRole2 Object

Objeto DatabaseRole.

DBFile Object

Objeto DataFile.

DBOption Object e DBOption2 Object

Movido para o objeto DatabaseOptions.

Default Object e Default2 Object

Objeto Default.

DistributionArticle Object e DistributionArticle2 Object

Movido para o namespace Microsoft.SqlServer.Replication.

DistributionDatabase Object e DistributionDatabase2 Object

Movido para o namespace Microsoft.SqlServer.Replication.

DistributionPublication Object e DistributionPublication2 Object

Movido para o namespace Microsoft.SqlServer.Replication.

DistributionSubscription Object e DistributionSubscription2 Object

Movido para o namespace Microsoft.SqlServer.Replication.

Distributor Object e Distributor2 Object

Movido para o namespace Microsoft.SqlServer.Replication.

DRIDefault Object

Movido para o objeto ScriptingOptions.

FileGroup Object e FileGroup2 Object

Objeto FileGroup.

FullTextCatalog Object e FullTextCatalog2 Object

Objetos FullTextCatalog e FullTextIndex.

Index Object e Index2 Object

Objeto Index.

Objeto IntegratedSecurity Object.

Funcionalidade movida para o objeto ServerConnection no namespace Microsoft.SqlServer.Management.Common.

Job Object

Objeto Job. Movido para o namespace Microsoft.SqlServer.Management.Smo.Agent.

JobFilter Object

Objeto JobFilter. Movido para o namespace Microsoft.SqlServer.Management.Smo.Agent.

JobHistoryFilter Object

Objeto JobHistoryFilter. Movido para o namespace Microsoft.SqlServer.Management.Smo.Agent.

JobSchedule Object

Objeto JobSchedule. Movido para o namespace Microsoft.SqlServer.Management.Smo.Agent.

JobServer Object e JobServer2 Object

Objeto JobServer. Movido para o namespace Microsoft.SqlServer.Management.Smo.Agent.

JobStep Object

Objeto JobStep. Movido para o namespace Microsoft.SqlServer.Management.Smo.Agent.

Key Object

Objetos ForeignKey e Index.

LinkedServer Object e LinkedServer2 Object

Objeto LinkedServer.

LinkedServerLogin Object

Objeto LinkedServerLogin.

LogFile Object

Objeto LogFile.

Login Object e Login2 Object

Objeto Login.

MergeArticle Object e MergeArticle2 Object

Objeto MergeArticle. Movido para o namespace Microsoft.SqlServer.Replication.

MergeDynamicSnapshotJob Object

Movido para o namespace Microsoft.SqlServer.Replication.

MergePublication Object e MergePublication2 Object

Objeto MergePublication. Movido para o namespace Microsoft.SqlServer.Replication.

MergePullSubscription Object e MergePullSubscription2 Object

Objeto MergePullSubscription. Movido para o namespace Microsoft.SqlServer.Replication.

MergeSubscription Object

Objeto MergeSubscription. Movido para o namespace Microsoft.SqlServer.Replication.

MergeSubsetFilter Object

Movido para o namespace N:Microsoft.SqlServer.Replication.

NameList Object

Removido. Funcionalidade alternativa no objeto Scripter.

Operator Object

Movido para o namespace Microsoft.SqlServer.Management.Smo.Agent.

Permission Object e Permission2 Object

Objetos ServerPermission, DatabasePermission, ApplicationRole e ObjectPermission.

Property Object

Objeto Property.

Publisher Object e Publisher2 Object

Objeto ReplicationServer. Movido para o namespace Microsoft.SqlServer.Replication.

QueryResults Object e QueryResults2 Object

Substituído pelo objeto do sistema DataTable ou DataSet.

RegisteredServer Object

Movido para o namespace Microsoft.SqlServer.Replication.

RegisteredSubscriber Object

Movido para o namespace Microsoft.SqlServer.Replication.

Registry Object e Registry2 Object

Removido.

RemoteLogin Object

Objeto ServerConnection. Movido para o namespace Common.

RemoteServer Object e RemoteServer2 Object

Objeto ServerConnection. Movido para o namespace Microsoft.SqlServer.Management.Common.

Replication Object

Movido para o namespace Microsoft.SqlServer.Replication.

ReplicationDatabase Object e ReplicationDatabase2 Object

Objeto ReplicationDatabase. Movido para o namespace Microsoft.SqlServer.Replication.

ReplicationSecurity Object

Objeto ServerConnection. Movido para o namespace Microsoft.SqlServer.Management.Common.

ReplicationStoredProcedure Object e ReplicationStoredProcedure2 Object

Objeto ReplicationStoredProcedure. Movido para o namespace Microsoft.SqlServer.Replication.

ReplicationTable Object e ReplicationTable2 Object

Objeto ReplicationTable. Movido para o namespace Microsoft.SqlServer.Replication.

Restore Object e Restore2 Object

Objetos Restore e BackupRestoreBase.

Rule Object e Rule2 Object

Objeto Rule.

Schedule Object

Movido para o namespace Microsoft.SqlServer.Replication.

ServerGroup Object

Removido.

ServerRole Object

Objeto ServerRole.

SQLObjectList Object

Matriz SqlSmoObject.

SQLServer Objecte SQLServer2 Object

Objeto Server.

StoredProcedure Object e StoredProcedure2 Object

Objetos StoredProcedure e StoredProcedureParameter.

Subscriber Object e Subscriber2 Object

Movido para o namespace Microsoft.SqlServer.Replication.

SystemDatatype Object e SystemDataType2 Object

Objeto DataType.

Table Object e Table2 Object

Objeto Table.

TargetServer Object

Movido para o namespace Microsoft.SqlServer.Management.Smo.Agent.

TargetServerGroup Object

Movido para o namespace Microsoft.SqlServer.Management.Smo.Agent.

TransactionLog Object

Funcionalidade movida para o objeto Database.

TransArticle Object e TransArticle2 Object

Objeto TransArticle. Movido para o namespace Microsoft.SqlServer.Replication.

Transfer Method e Transfer2 Object

Objeto Transfer.

TransPublication Object e TransPublication2 Object

Objeto TransPublication. Movido para o namespace Microsoft.SqlServer.Replication.

TransPullSubscription Object e TransPullSubscription2 Object

Objeto TransPullSubscription. Movido para o namespace Microsoft.SqlServer.Replication.

Trigger Object e Trigger2 Object

Objeto Trigger.

User Object e User2 Object

Objeto User.

UserDefinedDatatype Object e UserDefinedDataType2 Object

Objeto UserDefinedType.

UserDefinedFunction Object

Objetos UserDefinedFunction e UserDefinedFunctionParameter.

View Object e View2 Object

Objeto View.