private void btnGo_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
this.lstStatus.Items.Clear();
this.InitilizeHelperClass();
this.btnGo.Enabled = false;
ObjectScriptingConfigData cfgData = null;
switch (ddScriptType.SelectedItem.ToString())
{
case ScriptingType.FullSchemaScript:
cfgData = new ObjectScriptingConfigData(false, chkCombineTableObjects.Checked, chkZip.Checked, chkIncludeHeaders.Checked, true, this.connData);
break;
case ScriptingType.FullWithDelete:
cfgData = new ObjectScriptingConfigData(true, chkCombineTableObjects.Checked, chkZip.Checked, chkIncludeHeaders.Checked, true, this.connData);
break;
case ScriptingType.UpdateExistingFiles:
break;
}
bgScripting.RunWorkerAsync(cfgData);
}
finally
{
this.Cursor = Cursors.Default;
}
}
public SyncForm(string server, string userid, string password, string databaseName, string destinationDirectory)
{
InitializeComponent();
//Set the connection data
this.connData = new ConnectionData();
this.connData.DatabaseName = databaseName;
this.connData.SQLServerName = server;
this.connData.Password = password;
this.connData.UserId = userid;
this.connData.AuthenticationType = AuthenticationType.Password;
this.connData.StartingDirectory = destinationDirectory;
//Set the messagebox
StringBuilder sb = new StringBuilder();
sb.Append("Server:" + this.connData.SQLServerName + "\r\n");
sb.Append("DatabaseName:" + this.connData.DatabaseName + "\r\n");
sb.Append("UserId:" + this.connData.UserId + "\r\n");
sb.Append("Password:"******"\r\n");
sb.Append("StartingDirectory:" + this.connData.StartingDirectory + "\r\n");
MessageBox.Show(sb.ToString(), "Initilized");
ObjectScriptingConfigData cfgData = new ObjectScriptingConfigData(true, true, true, true, false, this.connData);
bgScripting.RunWorkerAsync(cfgData);
}
private void StartAutoScripting()
{
AutoScriptingConfig.DatabaseScriptConfigRow row = this.config.DatabaseScriptConfig[0];
ListViewItem newDb = new ListViewItem(new string[] { row.ServerName, row.DatabaseName, "Scripting", row.ScriptToPath });
lstDatabase.Items.Insert(0, newDb);
ConnectionData data = new ConnectionData();
data.DatabaseName = row.DatabaseName;
data.UserId = row.UserName;
data.Password = row.Password;
data.SQLServerName = row.ServerName;
data.AuthenticationType = (AuthenticationType)Enum.Parse(typeof(AuthenticationType), row.AuthenticationType);
data.StartingDirectory = row.ScriptToPath;
this.Text = "Scripting " + row.DatabaseName + " on " + row.ServerName + " :: ";
ObjectScriptingConfigData cfgData =
new ObjectScriptingConfigData(this.deletePreExisting, true, this.zipScripts, this.includeFileHeaders, false, data);
bgWorker.RunWorkerAsync(cfgData);
}
