SQL-DMO
Replication Initial Synchronization Constants (SQLDMO_INITIALSYNC_TYPE)
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 | Use Microsoft® SQL Server™ 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. |