Replication Initial Synchronization Constants (SQLDMO_INITIALSYNC_TYPE)
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.
Replication initial synchronization constants specify data file format used for an initial snapshot of data made to synchronize Publisher and Subscriber images of data replicated.
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 |
Uses concurrent snapshot generating character mode BCP files. It is required when 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. |