private void ProvisionMasterButton_Click(object sender, EventArgs e)
{
using (SqlConnection master = new SqlConnection(Settings.Default.MasterConnectionString))
{
try
{
// SpatialProvisioning.ProvisionDatabase(master, master, this.scopeNameTextBox.Text, this.sridTextBox.Text);
TableProvisioning.ProvisionTable(master, master, TableName, int.Parse(this.sridTextBox.Text), false);
MessageBox.Show("Database successfully provisioned for syncing.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, @"Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void ProvisionClientButton_Click(object sender, EventArgs e)
{
using (SqlConnection master = new SqlConnection(Settings.Default.MasterConnectionString), slave = new SqlConnection(Settings.Default.SlaveConnectionString))
{
try
{
using (SqlCommand command = slave.CreateCommand())
{
slave.Open();
command.CommandText = string.Format("IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[{0}]') AND type in (N'U')) DROP TABLE [dbo].[{0}]", TableName);
command.ExecuteNonQuery();
slave.Close();
}
// SpatialProvisioning.ProvisionDatabase(slave, master, this.scopeNameTextBox.Text, this.sridTextBox.Text);
TableProvisioning.ProvisionTable(master, slave, TableName, int.Parse(this.sridTextBox.Text), false);
MessageBox.Show("Database successfully provisioned for syncing.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, @"Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
