ReplicationDatabases Collection

Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 않도록 하고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.

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

Properties

Count Property

Methods

Item Method	Refresh Method
ItemByID Method	Script Method (Replication Objects)

주의

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)