• Article

ReplicationDatabases Collection

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The ReplicationDatabases collection contains ReplicationDatabase objects that enumerate the user-defined databases.

SQL-DMO object model that shows the current object

Properties

Count Property

Remarks

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)