SnapshotMethod Property
未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能，並計劃修改目前使用此功能的應用程式。
The SnapshotMethod property controls creation of the initial snapshot of published article data.
語法
object
.SnapshotMethod [= value]
Parts
- object
An expression that evaluates to an object in the Applies To list.
- value
A long integer that specifies snapshot creation parameters as described in Settings.
Data Type
Long, enumerated
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetSnapshotMethod(SQLDMO_INITIALSYNC_TYPE* pRetVal);
HRESULT SetSnapshotMethod(SQLDMO_INITIALSYNC_TYPE NewValue);
Settings
Set value using these SQLDMO_INITIALSYNC_TYPE values.
| Constant | Value | Description |
|---|---|---|
SQLDMOInitSync_BCPChar |
1 |
Uses Microsoft SQL Server bulk copy in character data format to transfer data for initial synchronization. |
SQLDMOInitSync_BCPNative |
0 |
Uses SQL Server bulk copy in native data format to transfer data for initial synchronization. |
SQLDMOInitSync_Concurrent |
3 |
Uses concurrent snapshot processing (transactional replication). |
SQLDMOInitSync_/ConcurrentChar |
4 |
Concurrent snapshot that generates character mode BCP files. It is required if the AllowDTS property is set to TRUE. |
SQLDMOInitSync_Default |
0 |
SQLDMOInitSync_BCPNative. |
SQLDMOInitSync_Max |
4 |
The maximum Initial Synchronization mode value. |
SQLDMOInitSync_Min |
0 |
SQLDMOInitSync_BCPNative. |
SQLDMOInitSync_Unknown |
10 |
The value is not valid. |
備註
If an application sets SnapshotMethod after the initial snapshot has been created, a new snapshot must be generated. Snapshots are applied when the next scheduled snapshot agent runs.