TransPublication Constructor

TransPublication Constructor

 

Creates a new instance of the TransPublication class.

Namespace:   Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

NameDescription
System_CAPS_pubmethodTransPublication()

Creates a new instance of the TransPublication class.

System_CAPS_pubmethodTransPublication(String, String, ServerConnection)

Creates a new instance of the TransPublication class with the required properties.

System_CAPS_pubmethodTransPublication(String, String, ServerConnection, Boolean)

Creates a new instance of the TransPublication class with the required properties, and indicates whether the Snapshot Agent job for the publication is created.

Updated text: 17 July 2006

The following table shows the default property values for a new instance of TransPublication. Any properties that are not explicitly enumerated in this table are initialized to a null value.

Property

Default value

Attributes

Values of AllowPush and SnapshotInDefaultFolder for

PublicationAttributes

CachePropertyChanges

false

ConflictPolicy

A value of PublisherWin for ConflictPolicyOption

ConflictRetention

14 (days)

ContinueOnConflict

false

CreateSnapshotAgentByDefault

false

FtpPort1

21

HasSubscription

false

IsExistingObject

false

QueueType

A value of Sql for QueueOption

ReplicateDdl

A value of All for DdlReplicationOptions

RetentionPeriod

0 (never expires)

SnapshotAgentExists

false

SnapshotAvailable

false

SnapshotGenerationAgentPublisherSecurity

A value of true for WindowsAuthentication

SnapshotMethod

A value of BcpNative for InitialSyncType

SnapshotSchedule

A value of 99991231 for ActiveEndDate

A value of 235959 for ActiveEndTime

A value of 0 for ActiveStartDate

A value of 0 for ActiveStartTime

A value of 1 for FrequencyInterval

A value of 0 for FrequencyRecurrenceFactor

A value of First for FrequencyRelativeInterval

A value of Hour for FrequencySubDay

A value of 1 for FrequencySubDayInterval

A value of Daily for FrequencyType

Status

A value of Active for State

Type

A value of Transactional for PublicationType

1 The FTP (file transfer protocol) port is used only if you transfer snapshots by using FTP. For more information, see Transfer Snapshots Through FTP.

Return to top
Show:
© 2016 Microsoft