SnapshotMethod Property
Dieses Feature wird in einer zukünftigen Version von Microsoft SQL Server entfernt. Verwenden Sie dieses Feature beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.
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. |
Hinweise
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.