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);
}
