后续版本的 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.