private void btnCopy_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(registeredServersSource.SelectedServer) == true || string.IsNullOrEmpty(registeredServersDestination.SelectedServer) == true)
{
throw new Exception("Enter a Source and Destination Server!");
}
if (registeredServersSource.SelectedServer == registeredServersDestination.SelectedServer)
{
throw new Exception("Source and destination cannot be the same!");
}
ConnectSqlServer connection = new ConnectSqlServer();
sourceserver = connection.Connect(registeredServersSource.SelectedServer);
Server destserver = connection.Connect(registeredServersDestination.SelectedServer);
if (sourceserver.VersionMajor < 9 || destserver.VersionMajor < 9)
{
throw new Exception("SQL Server versions prior to 2005 are not supported!");
}
if (sourceserver.VersionMajor > 10 && destserver.VersionMajor < 11)
{
throw new Exception(string.Format("Migration FROM SQL Server version {0} to {1} not supported!", sourceserver.VersionMajor.ToString(), destserver.VersionMajor.ToString()));
}
DateTime started = DateTime.Now;
showOutput.Clear();
showOutput.displayOutput(string.Format("Migration started: {0}", DateTime.Now.ToShortTimeString()));
switch (cboAction.SelectedItem.ToString())
{
case "Copy Accounts":
copyAccounts(destserver, chkDropDest.Checked);
break;
case "Copy Profiles":
copyProfiles(destserver, chkDropDest.Checked);
break;
default:
break;
}
showOutput.displayOutput(string.Format("Migration ended: {0}", DateTime.Now.ToShortTimeString()));
}
catch (Exception ex)
{
showOutput.displayOutput(ex.Message, true);
}
}
private void btnDisplay_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(registeredServersSource.SelectedServer) == true)
{
throw new Exception("Enter a Server!");
}
ConnectSqlServer connection = new ConnectSqlServer();
sourceserver = connection.Connect(registeredServersSource.SelectedServer);
if (sourceserver.VersionMajor < 9)
{
throw new Exception("SQL Server versions prior to 2005 are not supported!");
}
showProcesses(sourceserver);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnSelect_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(registeredServersSource.SelectedServer) == true)
{
throw new Exception("Enter a Source Server!");
}
ConnectSqlServer connection = new ConnectSqlServer();
sourceserver = connection.Connect(registeredServersSource.SelectedServer);
if (itemsToCopy.Count == 0)
{
setupJobList();
}
SelectItemsToCopy form = new SelectItemsToCopy();
form.ItemsToCopy = itemsToCopy;
form.ShowDialog();
itemsToCopy = form.ItemsToCopy;
}
catch (Exception ex)
{
showOutput.displayOutput(ex.Message, true);
}
}
private void btnCopy_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(registeredServersSource.SelectedServer) == true || string.IsNullOrEmpty(registeredServersDestination.SelectedServer) == true)
{
throw new Exception("Enter a Source and Destination Server!");
}
if (registeredServersSource.SelectedServer == registeredServersDestination.SelectedServer)
{
throw new Exception("Source and destination cannot be the same!");
}
ConnectSqlServer connection = new ConnectSqlServer();
Server sourceserver = connection.Connect(registeredServersSource.SelectedServer);
Server destserver = connection.Connect(registeredServersDestination.SelectedServer);
if (sourceserver.VersionMajor < 9 || destserver.VersionMajor < 9)
{
throw new Exception("SQL Server versions prior to 2005 are not supported!");
}
if (sourceserver.VersionMajor > 10 && destserver.VersionMajor < 11)
{
throw new Exception(string.Format("Migration FROM SQL Server version {0} to {1} not supported!", sourceserver.VersionMajor.ToString(), destserver.VersionMajor.ToString()));
}
if (itemsToCopy.Count == 0)
{
setupJobList();
}
;
DateTime started = DateTime.Now;
showOutput.Clear();
showOutput.displayOutput(string.Format("Migration started: {0}", DateTime.Now.ToShortTimeString()));
copyOperators(destserver);
showOutput.displayOutput(string.Format("Migration ended: {0}", DateTime.Now.ToShortTimeString()));
}
catch (Exception ex)
{
showOutput.displayOutput(ex.Message, true);
}
}
public ActionResult StartJob(JobDetailsModel step)
{
ConnectSqlServer connection = new ConnectSqlServer();
Server server = connection.Connect(step.ServerName);
server.JobServer.GetJobByID(step.JobID).Start(step.StepName);
server.ConnectionContext.Disconnect();
LogActivity log = new LogActivity();
log.Add(User.Identity.Name, step.ServerName, step.JobID, "Start Job");
return(RedirectToAction("Index", "Schedule", new { dbServer = step.ServerName }));
}
public Show_DatabaseDetails()
{
InitializeComponent();
ConnectSqlServer connection = new ConnectSqlServer();
Server sourceserver = connection.Connect(MainForm.dbServer);
db = sourceserver.Databases[MainForm.dbName];
listPages.Items.Add("General");
listPages.Items.Add("Files");
listPages.Items.Add("Options");
listPages.SelectedItem = "General";
}
private void btnSelect_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(registeredServersSource.SelectedServer) == true)
{
throw new Exception("Enter a Source Server!");
}
ConnectSqlServer connection = new ConnectSqlServer();
sourceserver = connection.Connect(registeredServersSource.SelectedServer);
if (itemsToCopy.Count == 0)
{
switch (cboAction.SelectedItem.ToString())
{
case "Copy Accounts":
foreach (MailAccount account in sourceserver.Mail.Accounts)
{
itemsToCopy.Add(new ItemToCopy(account.Name, false));
}
break;
case "Copy Profiles":
foreach (MailProfile profile in sourceserver.Mail.Profiles)
{
itemsToCopy.Add(new ItemToCopy(profile.Name, false));
}
break;
default:
break;
}
}
SelectItemsToCopy form = new SelectItemsToCopy();
form.ItemsToCopy = itemsToCopy;
form.ShowDialog();
itemsToCopy = form.ItemsToCopy;
}
catch (Exception ex)
{
showOutput.displayOutput(ex.Message, true);
}
}
public ActionResult StartJob(string dbServer, Guid jobID)
{
JobDetailsModel model = new JobDetailsModel();
PopulateDropDowns dropdown = new PopulateDropDowns();
ConnectSqlServer connection = new ConnectSqlServer();
Server server = connection.Connect(dbServer);
List <SelectListItem> stepList = new List <SelectListItem>();
stepList = dropdown.getSteps(dbServer, jobID);
ViewBag.StepList = stepList;
var job = server.JobServer.GetJobByID(jobID);
model.JobName = job.Name;
model.ServerName = dbServer;
model.JobID = jobID;
model.StepName = job.JobSteps[0].Name;
return(View(model));
}