Replication Article Pre-Creation Constants (SQLDMO_PREARTICLE_TYPE)

SQL-DMO

SQL-DMO

Replication Article Pre-Creation Constants (SQLDMO_PREARTICLE_TYPE)

Replication article precreation constants specify actions performed at a Subscriber prior to article synchronization.

Constant Value Description
SQLDMOPreArt_DeleteRows 2 Perform a logged delete prior to synchronization
SQLDMOPreArt_DropTable 1 Drop and recreate table to synchronize
SQLDMOPreArt_Max 3 SQLDMOPreArt_TruncateTable
SQLDMOPreArt_Min 0 SQLDMOPreArt_None
SQLDMOPreArt_None 0 Do nothing prior to synchronization
SQLDMOPreArt_TruncateTable 3 Perform a bulk-logged delete prior to synchronization