private void cmbFromServer_SelectedIndexChanged(object sender, EventArgs e) { txtFromServerUser.Text = mySettings.GetServerUsername(cmbFromServer.Text); txtFromServerPassword.Text = mySettings.GetServerPassword(cmbFromServer.Text); chkFromServerIntegrated.Checked = Convert.ToBoolean(mySettings.GetServerIntegratedSecurity(cmbFromServer.Text)); txtSourceDir.Text = mySettings.GetServerDefaultBackupdir(cmbFromServer.Text); }
static void Main(string[] args) { Console.Title = "SQL Server Database Copy Tool"; _settings = new cSettings(Application.StartupPath + "\\config.xml"); //check if we are in commandline with arguments if (args.Length > 0) { if (args.Length == 4) { //do things string sFromServer = args[0]; string sToServer = args[1]; string sFromDatabase = args[2]; string sToDatabase = args[3]; if (!PreCheckServer(sFromServer) || !PreCheckServer(sToServer)) { Application.Exit(); } else { cDatabaseCopy dbc = new cDatabaseCopy(); dbc.Progress += new ProgressEventHandler(OperationProgress); dbc.StepChanged += new StepsEventHandler(StepChanged); try { dbc.CopyDatabase(_settings.GetServerDefaultBackupdir(sFromServer), sFromDatabase, sToDatabase, _settings.GetServerDefaultDatadir(sToServer), _settings.GetServerDefaultBackupdir(sToServer), _settings.GetServerDefaultLogdir(sToServer), sFromServer, sToServer, _settings.GetServerUsername(sFromServer), _settings.GetServerPassword(sFromServer), _settings.GetServerIntegratedSecurity(sFromServer), _settings.GetServerUsername(sToServer), _settings.GetServerPassword(sToServer), _settings.GetServerIntegratedSecurity(sToServer)); } catch (Exception ex) { Console.WriteLine(ex.Message); Console.WriteLine("Exiting..."); Application.Exit(); } } } else { Console.WriteLine("No chance...! Use DbCopyTool.exe YOUR_FROM_SERVER YOUR_TO_SERVER YOUR_FROM_DB YOUR_TO_DB"); Console.WriteLine("Exiting..."); } } else { //hide console setConsoleWindowVisibility(false, Console.Title); Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); frmDBTools main = new frmDBTools(); Application.Run(main); } setConsoleWindowVisibility(true, Console.Title); }