ReplicationDatabases Collection
Esse recurso será removido em uma versão futura do Microsoft SQL Server. Evite usar esse recurso em desenvolvimentos novos e planeje modificar os aplicativos que atualmente o utilizam.
The ReplicationDatabases collection contains ReplicationDatabase objects that enumerate the user-defined databases.
Comentários
Microsoft SQL Server replication publications derive article data from only user-defined databases. To simplify replication configuration when using SQL Distributed Management Objects (SQL-DMO), SQL-DMO implements the ReplicationDatabases collection, which lists user-defined databases.
With the ReplicationDatabases collection, you can:
Enumerate user-defined databases on an instance of SQL Server.
Generate a Transact-SQL script to automate creation or other administration of all user-defined databases.
When using the Item method, the ReplicationDatabases collection supports member identification using either name or ordinal reference syntax. For example:
Set oReplicationDatabase = _
oSQLServer.Replication.oReplicationDatabases("Northwind")
Or:
Set oReplicationDatabase = _
oSQLServer.Replication.oReplicationDatabases(1)