TransSubscription 构造函数
定义
重要
一些信息与预发行产品相关,相应产品在发行之前可能会进行重大修改。 对于此处提供的信息,Microsoft 不作任何明示或暗示的担保。
创建类的新实例 TransSubscription 。
重载
| 名称 | 说明 |
|---|---|
| TransSubscription() |
创建类的新实例 TransSubscription 。 |
| TransSubscription(String, String, String, String, ServerConnection) |
创建一个新的类实例TransSubscription,包含指定的发布、数据库、Subscriber和subscriber数据库,并与Microsoft SQL Server实例有指定的连接。 |
注解
更新文本:2006年7月17日
下表显示了新实例的 TransSubscription默认属性值。 表中未明确枚举的任何属性都被初始化为一个 null 值。
| 财产 | 默认值 |
|---|---|
| AgentOffload | false |
| AgentSchedule | 99991231值 ActiveEndDate 235959 的值 ActiveEndTime 对于 ActiveStartDate 对于 ActiveStartTime 当值为1 FrequencyInterval 对于 FrequencyRecurrenceFactor First对于FrequencyRelativeIntervalMinute对于FrequencySubDay值为5,当 FrequencySubDayInterval Continuously对于FrequencyType |
| CachePropertyChanges | false |
| CreateSyncAgentByDefault | true |
| EnabledForSynchronizationManager | false |
| FullSubscription | true |
| IsExistingObject | false |
| LoopBackDetection | true |
| Status |
Inactive对于SubscriptionState |
| SubscriberDatasourceType |
SqlServer对于SubscriberType |
| SubscriberSecurity |
true对于WindowsAuthentication |
| SubscriberType |
ReadOnly对于TransSubscriberType |
| SubscriptionType |
Push对于SubscriptionOption |
| SynchronizationAgent | 与你创建的订阅相关的出版物中的一个实例 TransSynchronizationAgent 。 |
| SyncType |
Automatic对于SubscriptionSyncType |
TransSubscription()
创建类的新实例 TransSubscription 。
public:
TransSubscription();
public TransSubscription();
Public Sub New ()
示例
// Define the Publisher, publication, and databases.
string publicationName = "AdvWorksProductTran";
string publisherName = publisherInstance;
string subscriberName = subscriberInstance;
string subscriptionDbName = "AdventureWorks2012Replica";
string publicationDbName = "AdventureWorks2012";
//Create a connection to the Publisher.
ServerConnection conn = new ServerConnection(publisherName);
// Create the objects that we need.
TransPublication publication;
TransSubscription subscription;
try
{
// Connect to the Publisher.
conn.Connect();
// Ensure that the publication exists and that
// it supports push subscriptions.
publication = new TransPublication();
publication.Name = publicationName;
publication.DatabaseName = publicationDbName;
publication.ConnectionContext = conn;
if (publication.IsExistingObject)
{
if ((publication.Attributes & PublicationAttributes.AllowPush) == 0)
{
publication.Attributes |= PublicationAttributes.AllowPush;
}
// Define the push subscription.
subscription = new TransSubscription();
subscription.ConnectionContext = conn;
subscription.SubscriberName = subscriberName;
subscription.PublicationName = publicationName;
subscription.DatabaseName = publicationDbName;
subscription.SubscriptionDBName = subscriptionDbName;
// Specify the Windows login credentials for the Distribution Agent job.
subscription.SynchronizationAgentProcessSecurity.Login = winLogin;
subscription.SynchronizationAgentProcessSecurity.Password = winPassword;
// By default, subscriptions to transactional publications are synchronized
// continuously, but in this case we only want to synchronize on demand.
subscription.AgentSchedule.FrequencyType = ScheduleFrequencyType.OnDemand;
// Create the push subscription.
subscription.Create();
}
else
{
// Do something here if the publication does not exist.
throw new ApplicationException(String.Format(
"The publication '{0}' does not exist on {1}.",
publicationName, publisherName));
}
}
catch (Exception ex)
{
// Implement the appropriate error handling here.
throw new ApplicationException(String.Format(
"The subscription to {0} could not be created.", publicationName), ex);
}
finally
{
conn.Disconnect();
}
' Define the Publisher, publication, and databases.
Dim publicationName As String = "AdvWorksProductTran"
Dim publisherName As String = publisherInstance
Dim subscriberName As String = subscriberInstance
Dim subscriptionDbName As String = "AdventureWorks2012Replica"
Dim publicationDbName As String = "AdventureWorks2012"
'Create a connection to the Publisher.
Dim conn As ServerConnection = New ServerConnection(publisherName)
' Create the objects that we need.
Dim publication As TransPublication
Dim subscription As TransSubscription
Try
' Connect to the Publisher.
conn.Connect()
' Ensure that the publication exists and that
' it supports push subscriptions.
publication = New TransPublication()
publication.Name = publicationName
publication.DatabaseName = publicationDbName
publication.ConnectionContext = conn
If publication.IsExistingObject Then
If (publication.Attributes And PublicationAttributes.AllowPush) = 0 Then
publication.Attributes = publication.Attributes _
Or PublicationAttributes.AllowPush
End If
' Define the push subscription.
subscription = New TransSubscription()
subscription.ConnectionContext = conn
subscription.SubscriberName = subscriberName
subscription.PublicationName = publicationName
subscription.DatabaseName = publicationDbName
subscription.SubscriptionDBName = subscriptionDbName
' Specify the Windows login credentials for the Distribution Agent job.
subscription.SynchronizationAgentProcessSecurity.Login = winLogin
subscription.SynchronizationAgentProcessSecurity.Password = winPassword
' By default, subscriptions to transactional publications are synchronized
' continuously, but in this case we only want to synchronize on demand.
subscription.AgentSchedule.FrequencyType = ScheduleFrequencyType.OnDemand
' Create the push subscription.
subscription.Create()
Else
' Do something here if the publication does not exist.
Throw New ApplicationException(String.Format( _
"The publication '{0}' does not exist on {1}.", _
publicationName, publisherName))
End If
Catch ex As Exception
' Implement the appropriate error handling here.
Throw New ApplicationException(String.Format( _
"The subscription to {0} could not be created.", publicationName), ex)
Finally
conn.Disconnect()
End Try
注解
默认构造函数会将任何字段初始化为其默认值。
另请参阅
适用于
TransSubscription(String, String, String, String, ServerConnection)
创建一个新的类实例TransSubscription,包含指定的发布、数据库、Subscriber和subscriber数据库,并与Microsoft SQL Server实例有指定的连接。
public:
TransSubscription(System::String ^ publicationName, System::String ^ databaseName, System::String ^ subscriberName, System::String ^ subscriptionDBName, Microsoft::SqlServer::Management::Common::ServerConnection ^ connectionContext);
public TransSubscription(string publicationName, string databaseName, string subscriberName, string subscriptionDBName, Microsoft.SqlServer.Management.Common.ServerConnection connectionContext);
new Microsoft.SqlServer.Replication.TransSubscription : string * string * string * string * Microsoft.SqlServer.Management.Common.ServerConnection -> Microsoft.SqlServer.Replication.TransSubscription
Public Sub New (publicationName As String, databaseName As String, subscriberName As String, subscriptionDBName As String, connectionContext As ServerConnection)
参数
- connectionContext
- ServerConnection
代表ServerConnection与Publisher或分发商的非SQL Server Publisher订阅连接的对象。