ReplicationDatabases Collection (SQL-DMO)

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

Remarks

Microsoft® SQL Server™ replication publications derive article data from only user-defined databases. To simplify replication configuration when using SQL-DMO, SQL-DMO implements the ReplicationDatabases collection, which lists user-defined databases.

With the ReplicationDatabases collection, you can:

• Enumerate user-defined databases on a SQL Server installation.
• Generate a Transact-SQL script that can be used 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)

Methods

Properties

Count Property