Share via


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 SnapshotMethodafter the initial snapshot has been created, a new snapshot must be generated. Snapshots are applied when the next scheduled snapshot agent runs.