SnapshotMethod Property
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The SnapshotMethod property controls creation of the initial snapshot of published article data.
Syntax
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. |
Remarks
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.