SQL-DMO
SnapshotMethod Property
The SnapshotMethod property controls creation of the initial snapshot of published article data.
Applies To
| MergePublication Object | TransPublication Object |
Syntax
object.SnapshotMethod [= value]
Parts
object
Expression that evaluates to an object in the Applies To list
value
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 | Use Microsoft® SQL Server™ 2000 bulk copy in character data format to transfer data for initial synchronization. |
| SQLDMOInitSync_BCPNative | 0 | Use SQL Server bulk copy in native data format to transfer data for initial synchronization. |
| SQLDMOInitSync_Concurrent | 3 | Use concurrent snapshot processing (transactional replication). |
| SQLDMOInitSync_ConcurrentChar | 4 | Concurrent snapshot generating character mode BCP files. Required when the AllowDTS property is set to True. |
| SQLDMOInitSync_Default | 0 | SQLDMOInitSync_BCPNative. |
| SQLDMOInitSync_Max | 4 | Maximum Initial Synchronization mode value. |
| SQLDMOInitSync_Min | 0 | SQLDMOInitSync_BCPNative. |
| SQLDMOInitSync_Unknown | 10 | Bad or invalid value. |
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.