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.