TransPublication Constructors

Definition

Namespace:

Microsoft.SqlServer.Replication

Assembly:

Microsoft.SqlServer.Rmo.dll

Creates a new instance of the TransPublication class.

Overloads

TransPublication()	Creates a new instance of the TransPublication class.
TransPublication(String, String, ServerConnection)	Creates a new instance of the TransPublication class with the required properties.
TransPublication(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.

Remarks

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
FtpPort 1	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

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

TransPublication()

Creates a new instance of the TransPublication class.

public:
 TransPublication();

public TransPublication ();

Public Sub New ()

TransPublication(String, String, ServerConnection)

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

public:
 TransPublication(System::String ^ name, System::String ^ databaseName, Microsoft::SqlServer::Management::Common::ServerConnection ^ connectionContext);

public TransPublication (string name, string databaseName, Microsoft.SqlServer.Management.Common.ServerConnection connectionContext);

new Microsoft.SqlServer.Replication.TransPublication : string * string * Microsoft.SqlServer.Management.Common.ServerConnection -> Microsoft.SqlServer.Replication.TransPublication

Public Sub New (name As String, databaseName As String, connectionContext As ServerConnection)

Parameters

name

String

A String value that specifies the name of publication.

databaseName

String

A String value that specifies the name of the publication database.

connectionContext

ServerConnection

A ServerConnection object that represents a connection to the Publisher or to the Distributor for a non-SQL Server Publisher.

TransPublication(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.

public:
 TransPublication(System::String ^ name, System::String ^ databaseName, Microsoft::SqlServer::Management::Common::ServerConnection ^ connectionContext, bool createSnapshotAgentByDefault);

public TransPublication (string name, string databaseName, Microsoft.SqlServer.Management.Common.ServerConnection connectionContext, bool createSnapshotAgentByDefault);

new Microsoft.SqlServer.Replication.TransPublication : string * string * Microsoft.SqlServer.Management.Common.ServerConnection * bool -> Microsoft.SqlServer.Replication.TransPublication

Public Sub New (name As String, databaseName As String, connectionContext As ServerConnection, createSnapshotAgentByDefault As Boolean)

Parameters

name

String

A String value that specifies the name of publication.

databaseName

String

A String value that specifies the name of the publication database.

connectionContext

ServerConnection

A ServerConnection object that represents a connection to the Publisher or to the Distributor for a non-SQL Server Publisher.

createSnapshotAgentByDefault

Boolean

A Boolean value that indicates whether the Snapshot Agent job is added automatically when the publication is created.