public void CreateSubscription()
{
// The publication must support anonymous Subscribers, pull
// subscriptions, and Web synchronization.
// Define the Publisher, publication, and databases.
string publicationName = "HdHouse-Pub";
string publisherName = PublisherInstance;
string subscriberName = SubscriberInstance;
string subscriptionDbName = "HdHouseReplica";
string publicationDbName = "HdHouse";
string hostname = "RD03";
string webSyncUrl = "https://" + PublisherInstance + "/hdhouse-dbpub/replisapi.dll";
//Create the Subscriber connection.
ServerConnection conn = new ServerConnection(subscriberName);
// Create the objects that we need.
MergePullSubscription subscription;
try
{
// Connect to the Subscriber.
conn.Connect();
// Define the pull subscription.
subscription = new MergePullSubscription();
subscription.ConnectionContext = conn;
subscription.PublisherName = publisherName;
subscription.PublicationName = publicationName;
subscription.PublicationDBName = publicationDbName;
subscription.DatabaseName = subscriptionDbName;
subscription.HostName = hostname;
// Specify an anonymous Subscriber type since we can't
// register at the Publisher with a direct connection.
subscription.SubscriberType = MergeSubscriberType.Anonymous;
// Specify the Windows login credentials for the Merge Agent job.
subscription.SynchronizationAgentProcessSecurity.Login = WinLogin;
subscription.SynchronizationAgentProcessSecurity.Password = WinPassword;
// Enable Web synchronization.
subscription.UseWebSynchronization = true;
subscription.InternetUrl = webSyncUrl;
// Specify the same Windows credentials to use when connecting to the
// Web server using HTTPS Basic Authentication.
subscription.InternetSecurityMode = AuthenticationMethod.BasicAuthentication;
subscription.InternetLogin = WinLogin;
subscription.InternetPassword = WinPassword;
// Create the subscription database using SMO if it does not exist.
ReplicationDatabase replDatabase;
Database newDatabase;
Server subServer = new Server(conn);
replDatabase = new ReplicationDatabase(
subscription.DatabaseName, conn);
newDatabase = subServer.Databases[replDatabase.Name];
// Create the subscription database.
if (subServer.Databases.Contains(replDatabase.Name) == false)
{
//currentStatusTextBox.Text += statusCreateDatabase
// + Environment.NewLine;
//Application.DoEvents();
newDatabase = new Database(subServer, replDatabase.Name);
newDatabase.Create();
}
replDatabase.Load();
replDatabase.EnabledMergePublishing = false;
replDatabase.CommitPropertyChanges();
// Ensure that we create a job for this subscription.
subscription.CreateSyncAgentByDefault = true;
// Create the pull subscription at the Subscriber.
subscription.Create();
// 订阅创建成功，进行初始化同步
}
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();
}
}
public void CreateSubscription()
{
// The publication must support anonymous Subscribers, pull
// subscriptions, and Web synchronization.
// Define the Publisher, publication, and databases.
string publicationName = "HdHouse-Pub";
string publisherName = PublisherInstance;
string subscriberName = SubscriberInstance;
string subscriptionDbName = "HdHouseReplica";
string publicationDbName = "HdHouse";
string hostname = "RD03";
string webSyncUrl = "https://" + PublisherInstance + "/hdhouse-dbpub/replisapi.dll";
//Create the Subscriber connection.
ServerConnection conn = new ServerConnection(subscriberName);
// Create the objects that we need.
MergePullSubscription subscription;
try
{
// Connect to the Subscriber.
conn.Connect();
// Define the pull subscription.
subscription = new MergePullSubscription();
subscription.ConnectionContext = conn;
subscription.PublisherName = publisherName;
subscription.PublicationName = publicationName;
subscription.PublicationDBName = publicationDbName;
subscription.DatabaseName = subscriptionDbName;
subscription.HostName = hostname;
// Specify an anonymous Subscriber type since we can't
// register at the Publisher with a direct connection.
subscription.SubscriberType = MergeSubscriberType.Anonymous;
// Specify the Windows login credentials for the Merge Agent job.
subscription.SynchronizationAgentProcessSecurity.Login = WinLogin;
subscription.SynchronizationAgentProcessSecurity.Password = WinPassword;
// Enable Web synchronization.
subscription.UseWebSynchronization = true;
subscription.InternetUrl = webSyncUrl;
// Specify the same Windows credentials to use when connecting to the
// Web server using HTTPS Basic Authentication.
subscription.InternetSecurityMode = AuthenticationMethod.BasicAuthentication;
subscription.InternetLogin = WinLogin;
subscription.InternetPassword = WinPassword;
// Create the subscription database using SMO if it does not exist.
ReplicationDatabase replDatabase;
Database newDatabase;
Server subServer = new Server(conn);
replDatabase = new ReplicationDatabase(
subscription.DatabaseName, conn);
newDatabase = subServer.Databases[replDatabase.Name];
// Create the subscription database.
if (subServer.Databases.Contains(replDatabase.Name) == false)
{
//currentStatusTextBox.Text += statusCreateDatabase
// + Environment.NewLine;
//Application.DoEvents();
newDatabase = new Database(subServer, replDatabase.Name);
newDatabase.Create();
}
replDatabase.Load();
replDatabase.EnabledMergePublishing = false;
replDatabase.CommitPropertyChanges();
// Ensure that we create a job for this subscription.
subscription.CreateSyncAgentByDefault = true;
// Create the pull subscription at the Subscriber.
subscription.Create();
// 订阅创建成功，进行初始化同步
}
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();
}
}
private void CreateSubscription()
{
ReplicationDatabase replDatabase;
Server subServer;
Database newDatabase;
MergeSynchronizationAgent syncAgent;
ReplicationServer Subscriber;
BusinessLogicHandler insertUpdateHandler;
Boolean isRegistered = false;
this.Show();
Application.DoEvents();
// We need to collect valid Windows credentials to be able to
// store Web synchronization information in the database.
LogonUser logon = new LogonUser();
DialogResult dr = logon.ShowDialog(this);
string username = logon.UserName;
string password = logon.Password;
if (dr == DialogResult.OK)
{
//try
//{
// // Create connections to the Publisher and Distributor.
// publisherConn = new ServerConnection(publisherServer);
// publisherConn.Connect();
//}
//catch (Microsoft.SqlServer.Replication.ConnectionFailureException ex)
//{
// ExceptionMessageBox emb = new ExceptionMessageBox(
// Properties.Resources.ExceptionCannotConnectPublisher,
// Properties.Resources.ExceptionSqlServerError,
// ExceptionMessageBoxButtons.OK);
// emb.InnerException = ex;
// emb.Show(this);
// // Shutdown the application because we can't continue.
// Application.Exit();
//}
try
{
// Make the connection and get the subscription properties.
subscriberConn = new ServerConnection(subscriberServer);
subscriberConn.Connect();
}
catch (Microsoft.SqlServer.Replication.ConnectionFailureException ex)
{
ExceptionMessageBox emb = new ExceptionMessageBox(
Properties.Resources.ExceptionCannotConnectLocal,
Properties.Resources.ExceptionSqlServerError,
ExceptionMessageBoxButtons.OK);
emb.InnerException = ex;
emb.Show(this);
// Shutdown the application because we can't continue.
Application.Exit();
}
// Instantiate a pull subscription object.
mergePullSub = new MergePullSubscription();
// Set the required properties needed to create the subscription.
mergePullSub.ConnectionContext = subscriberConn;
mergePullSub.PublicationName = publicationName;
mergePullSub.PublisherName = publisherServer;
mergePullSub.PublicationDBName = publicationDatabase;
mergePullSub.DatabaseName = subscriptionDatabase;
// Specify an anonymous Subscriber type since we can't
// register at the Publisher with a direct connection.
mergePullSub.SubscriberType = MergeSubscriberType.Anonymous;
// Enable Web synchronization.
mergePullSub.UseWebSynchronization = true;
mergePullSub.InternetUrl = Properties.Settings.Default.WebSynchronizationUrl;
// Specify the same Windows credentials to use when connecting to the
// Web server using HTTPS Basic Authentication.
mergePullSub.InternetSecurityMode = AuthenticationMethod.BasicAuthentication;
//mergePullSub.InternetLogin = username;
//mergePullSub.InternetPassword = password;
mergePullSub.InternetLogin = internetLogin;
mergePullSub.InternetPassword = internetPassword;
// Create the subscription database using SMO if it does not exist.
subServer = new Server(subscriberConn);
replDatabase = new ReplicationDatabase(
mergePullSub.DatabaseName, subscriberConn);
newDatabase = subServer.Databases[replDatabase.Name];
// Create the subscription database.
if (subServer.Databases.Contains(replDatabase.Name) == false)
{
currentStatusTextBox.Text += statusCreateDatabase
+ Environment.NewLine;
Application.DoEvents();
newDatabase = new Database(subServer, replDatabase.Name);
newDatabase.Create();
}
replDatabase.Load();
replDatabase.EnabledMergePublishing = false;
replDatabase.CommitPropertyChanges();
// This is needed so that we can store Web synchronization
// information in the MSsubscription_properties table and access this
// information using the MergePullSubscription class. For a SQL Server 2005
// Subscriber an agent job will be created. For a SQL Server 2005 Express Edition
// Subscriber, only the meta data will be created because this edition does not
// support SQL Server Agent.
mergePullSub.CreateSyncAgentByDefault = true;
// Set the process security which is required for the agent job.
mergePullSub.SynchronizationAgentProcessSecurity.Login = username;
mergePullSub.SynchronizationAgentProcessSecurity.Password = password;
// Set the HostName property.
mergePullSub.HostName = subscriberHostName;
// 调用 远程接口注册该订阅
/*DBCenterWebService service = new DBCenterWebService();
* SubscriptionInfo info = new SubscriptionInfo();
* info.subscriberName = mergePullSub.Name;
* info.subscriptionDbName = mergePullSub.DatabaseName;
* service.CreateSubscriptionRequest(info);*/
//if (!mergePub.SnapshotAvailable)
//{
// throw new ApplicationException(
// Properties.Resources.ExceptionSalesDataNotAvailable
// + Environment.NewLine
// + Properties.Resources.ExceptionContactTechSupport);
//}
// Define the handler for inserts and updates at the Subscriber.
Subscriber = new ReplicationServer(subscriberConn);
insertUpdateHandler = new BusinessLogicHandler();
insertUpdateHandler.FriendlyName = handlerFriendlyName;
insertUpdateHandler.DotNetAssemblyName = "BusinessLogic.dll";
insertUpdateHandler.DotNetClassName = "Microsoft.Samples.SqlServer.CustomBusinessLogicHandler";
insertUpdateHandler.IsDotNetAssembly = true;
try
{
// Create the pull subscription.
currentStatusTextBox.Text += statusCreateSubscription
+ Environment.NewLine;
Application.DoEvents();
mergePullSub.Create();
mergePullSub.Refresh();
// Get the Merge Agent for synchronous execution.
syncAgent = mergePullSub.SynchronizationAgent;
// We have to set these because of an RMO bug.
// Remove for RTM.
syncAgent.DistributorSecurityMode = SecurityMode.Integrated;
syncAgent.PublisherSecurityMode = SecurityMode.Integrated;
syncAgent.SubscriberSecurityMode = SecurityMode.Integrated;
// Generate a troubleshooting log file.
syncAgent.OutputVerboseLevel = outputLevel;
syncAgent.Output = outputLogFile;
// Define the event handler.
syncAgent.Status
+= new AgentCore.StatusEventHandler(Sync_Status);
currentStatusTextBox.Text += statusInitialize
+ Environment.NewLine;
Application.DoEvents();
// Start the Merge Agent synchronously to apply the initial snapshot.
syncAgent.Synchronize();
// Make sure that the initialization was successful.
mergePullSub.Refresh();
if (mergePullSub.LastAgentStatus
!= ReplicationStatus.Succeeded)
{
throw new SubscriptionInitializationException(
Properties.Resources.ExceptionSubscriptionNotSync);
}
currentStatusTextBox.Text += statusSuccess.ToString()
+ Environment.NewLine;
statusProgressBar.Value = 100;
}
catch (Exception ex)
{
currentStatusTextBox.Text += statusFail.ToString()
+ Environment.NewLine;
statusProgressBar.Value = 0;
// If an exception occurs, undo subscription registration at both
// the Publisher and Subscriber and remove the handler registration.
mergePullSub.Remove();
if (isRegistered)
{
Subscriber.UnregisterBusinessLogicHandler(insertUpdateHandler);
isRegistered = false;
}
throw new SubscriptionCreationException(
Properties.Resources.ExceptionSubscriptionNotCreated,
ex);
}
finally
{
closeButton.Enabled = true;
subscriberConn.Disconnect();
//publisherConn.Disconnect();
}
}
else
{
// If we can't create the subscription, close the application.
ExceptionMessageBox emb = new ExceptionMessageBox(
Properties.Resources.ExceptionSubscriptionNotCreated);
emb.Buttons = ExceptionMessageBoxButtons.RetryCancel;
DialogResult drRetry = emb.Show(this);
if (drRetry == DialogResult.Retry)
{
this.CreateSubscription();
}
else
{
Application.Exit();
}
}
}
private void CreateSubscription()
{
ReplicationDatabase replDatabase;
Server subServer;
Database newDatabase;
MergeSynchronizationAgent syncAgent;
ReplicationServer Subscriber;
BusinessLogicHandler insertUpdateHandler;
Boolean isRegistered = false;
this.Show();
Application.DoEvents();
// We need to collect valid Windows credentials to be able to
// store Web synchronization information in the database.
LogonUser logon = new LogonUser();
DialogResult dr = logon.ShowDialog(this);
string username = logon.UserName;
string password = logon.Password;
if (dr == DialogResult.OK)
{
//try
//{
// // Create connections to the Publisher and Distributor.
// publisherConn = new ServerConnection(publisherServer);
// publisherConn.Connect();
//}
//catch (Microsoft.SqlServer.Replication.ConnectionFailureException ex)
//{
// ExceptionMessageBox emb = new ExceptionMessageBox(
// Properties.Resources.ExceptionCannotConnectPublisher,
// Properties.Resources.ExceptionSqlServerError,
// ExceptionMessageBoxButtons.OK);
// emb.InnerException = ex;
// emb.Show(this);
// // Shutdown the application because we can't continue.
// Application.Exit();
//}
try
{
// Make the connection and get the subscription properties.
subscriberConn = new ServerConnection(subscriberServer);
subscriberConn.Connect();
}
catch (Microsoft.SqlServer.Replication.ConnectionFailureException ex)
{
ExceptionMessageBox emb = new ExceptionMessageBox(
Properties.Resources.ExceptionCannotConnectLocal,
Properties.Resources.ExceptionSqlServerError,
ExceptionMessageBoxButtons.OK);
emb.InnerException = ex;
emb.Show(this);
// Shutdown the application because we can't continue.
Application.Exit();
}
// Instantiate a pull subscription object.
mergePullSub = new MergePullSubscription();
// Set the required properties needed to create the subscription.
mergePullSub.ConnectionContext = subscriberConn;
mergePullSub.PublicationName = publicationName;
mergePullSub.PublisherName = publisherServer;
mergePullSub.PublicationDBName = publicationDatabase;
mergePullSub.DatabaseName = subscriptionDatabase;
// Specify an anonymous Subscriber type since we can't
// register at the Publisher with a direct connection.
mergePullSub.SubscriberType = MergeSubscriberType.Anonymous;
// Enable Web synchronization.
mergePullSub.UseWebSynchronization = true;
mergePullSub.InternetUrl = Properties.Settings.Default.WebSynchronizationUrl;
// Specify the same Windows credentials to use when connecting to the
// Web server using HTTPS Basic Authentication.
mergePullSub.InternetSecurityMode = AuthenticationMethod.BasicAuthentication;
//mergePullSub.InternetLogin = username;
//mergePullSub.InternetPassword = password;
mergePullSub.InternetLogin = internetLogin;
mergePullSub.InternetPassword = internetPassword;
// Create the subscription database using SMO if it does not exist.
subServer = new Server(subscriberConn);
replDatabase = new ReplicationDatabase(
mergePullSub.DatabaseName, subscriberConn);
newDatabase = subServer.Databases[replDatabase.Name];
// Create the subscription database.
if (subServer.Databases.Contains(replDatabase.Name) == false)
{
currentStatusTextBox.Text += statusCreateDatabase
+ Environment.NewLine;
Application.DoEvents();
newDatabase = new Database(subServer, replDatabase.Name);
newDatabase.Create();
}
replDatabase.Load();
replDatabase.EnabledMergePublishing = false;
replDatabase.CommitPropertyChanges();
// This is needed so that we can store Web synchronization
// information in the MSsubscription_properties table and access this
// information using the MergePullSubscription class. For a SQL Server 2005
// Subscriber an agent job will be created. For a SQL Server 2005 Express Edition
// Subscriber, only the meta data will be created because this edition does not
// support SQL Server Agent.
mergePullSub.CreateSyncAgentByDefault = true;
// Set the process security which is required for the agent job.
mergePullSub.SynchronizationAgentProcessSecurity.Login = username;
mergePullSub.SynchronizationAgentProcessSecurity.Password = password;
// Set the HostName property.
mergePullSub.HostName = subscriberHostName;
// 调用 远程接口注册该订阅
/*DBCenterWebService service = new DBCenterWebService();
SubscriptionInfo info = new SubscriptionInfo();
info.subscriberName = mergePullSub.Name;
info.subscriptionDbName = mergePullSub.DatabaseName;
service.CreateSubscriptionRequest(info);*/
//if (!mergePub.SnapshotAvailable)
//{
// throw new ApplicationException(
// Properties.Resources.ExceptionSalesDataNotAvailable
// + Environment.NewLine
// + Properties.Resources.ExceptionContactTechSupport);
//}
// Define the handler for inserts and updates at the Subscriber.
Subscriber = new ReplicationServer(subscriberConn);
insertUpdateHandler = new BusinessLogicHandler();
insertUpdateHandler.FriendlyName = handlerFriendlyName;
insertUpdateHandler.DotNetAssemblyName = "BusinessLogic.dll";
insertUpdateHandler.DotNetClassName = "Microsoft.Samples.SqlServer.CustomBusinessLogicHandler";
insertUpdateHandler.IsDotNetAssembly = true;
try
{
// Create the pull subscription.
currentStatusTextBox.Text += statusCreateSubscription
+ Environment.NewLine;
Application.DoEvents();
mergePullSub.Create();
mergePullSub.Refresh();
// Get the Merge Agent for synchronous execution.
syncAgent = mergePullSub.SynchronizationAgent;
// We have to set these because of an RMO bug.
// Remove for RTM.
syncAgent.DistributorSecurityMode = SecurityMode.Integrated;
syncAgent.PublisherSecurityMode = SecurityMode.Integrated;
syncAgent.SubscriberSecurityMode = SecurityMode.Integrated;
// Generate a troubleshooting log file.
syncAgent.OutputVerboseLevel = outputLevel;
syncAgent.Output = outputLogFile;
// Define the event handler.
syncAgent.Status
+= new AgentCore.StatusEventHandler(Sync_Status);
currentStatusTextBox.Text += statusInitialize
+ Environment.NewLine;
Application.DoEvents();
// Start the Merge Agent synchronously to apply the initial snapshot.
syncAgent.Synchronize();
// Make sure that the initialization was successful.
mergePullSub.Refresh();
if (mergePullSub.LastAgentStatus
!= ReplicationStatus.Succeeded)
{
throw new SubscriptionInitializationException(
Properties.Resources.ExceptionSubscriptionNotSync);
}
currentStatusTextBox.Text += statusSuccess.ToString()
+ Environment.NewLine;
statusProgressBar.Value = 100;
}
catch (Exception ex)
{
currentStatusTextBox.Text += statusFail.ToString()
+ Environment.NewLine;
statusProgressBar.Value = 0;
// If an exception occurs, undo subscription registration at both
// the Publisher and Subscriber and remove the handler registration.
mergePullSub.Remove();
if (isRegistered)
{
Subscriber.UnregisterBusinessLogicHandler(insertUpdateHandler);
isRegistered = false;
}
throw new SubscriptionCreationException(
Properties.Resources.ExceptionSubscriptionNotCreated,
ex);
}
finally
{
closeButton.Enabled = true;
subscriberConn.Disconnect();
//publisherConn.Disconnect();
}
}
else
{
// If we can't create the subscription, close the application.
ExceptionMessageBox emb = new ExceptionMessageBox(
Properties.Resources.ExceptionSubscriptionNotCreated);
emb.Buttons = ExceptionMessageBoxButtons.RetryCancel;
DialogResult drRetry = emb.Show(this);
if (drRetry == DialogResult.Retry)
{
this.CreateSubscription();
}
else
{
Application.Exit();
}
}
}
