ReplicationFrequency Property
Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 않도록 하고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.
The ReplicationFrequency property sets the method used to determine article publication.
구문
object.ReplicationFrequency [= value]
Parts
object
An expression that evaluates to an object in the Applies To list.value
A long integer that specifies article publication as described in Settings.
Data Type
Long, enumerated
Modifiable
Read/write when using the SQL Distributed Management Objects (SQL-DMO) object to create a publication.
Read-only when the object references an existing publication.
Prototype (C/C++)
HRESULT GetReplicationFrequency(SQLDMO_REPFREQ_TYPE* pRetVal);
HRESULT SetReplicationFrequency(SQLDMO_REPFREQ_TYPE NewValue);
Settings
Constant |
Value |
Description |
|---|---|---|
SQLDMORepFreq_Continuous |
0 |
Log monitoring or another method is used to determine replicated article content. |
SQLDMORepFreq_Snapshot |
1 |
The article is replicated at fixed times and is not dependent upon transaction log monitoring or other monitoring processes. |
SQLDMORepFreq_Unknown |
1000 |
The value is not valid. |
주의
Microsoft SQL Server supports two types of transactional replication. In the first instance, data is replicated at fixed intervals regardless of any changes made to that data. This type of transactional replication is more often identified as snapshot replication, because the data is simply copied as it exists at a given moment. Transactional replication can also determine replicated values based on changes made to that data. By default, SQL Server replication monitors changes to the transaction log of a database to determine which values are replicated.
Setting the ReplicationFrequency property controls the type of transactional replication defined by the TransPublication object and is part of creating transactional and snapshot replication publications. For more information, see TransPublication Object.