bool StartProcess()
{
try
{
//int ServerID;
Steps.AddSQLServerInstance(Config.ServerOptions_CMWIN2016SQL17); //CMWIN2016SQL17
}
catch (Exception ex)
{
Reports.ReportLog(ex.Message, Reports.SQLdmReportLevel.Fail, null, Config.TestCaseName);
}
return(true);
}
bool StartProcess()
{
try
{
Steps.AddSQLServerInstance(Config.ServerOptions_DEFAULTSERVER); //CMWIN2016-S8
Steps.AddSQLServerInstance(Config.ServerOptions_SQLAUTHSERVER); //T-MSSQL2016
}
catch (Exception ex)
{
Reports.ReportLog(ex.Message, Reports.SQLdmReportLevel.Fail, null, Config.TestCaseName);
}
return(true);
}
bool StartProcess()
{
try
{
Steps.AddSQLServerInstance(Config.ServerOptions_CMWIN2016SQL17); //CMWIN2016SQL17
Steps.VerifyQueryDataCount(Config.Query_MonitoredSQLServers, "MonitoredSQLServers");
Steps.DeleteSQLServerInstance(Config.ServerOptions_CMWIN2016SQL17); //CMWIN2016SQL17
Steps.VerifyInstanceIsDeleted("select * from AnalysisConfiguration where MonitoredServerID = 6", "AnalysisConfiguration");
}
catch (Exception ex)
{
Reports.ReportLog(ex.Message, Reports.SQLdmReportLevel.Fail, null, Config.TestCaseName);
}
return(true);
}
bool StartProcess()
{
try
{
string ServerID = "";
Steps.AddSQLServerInstance(Config.ServerOptions_FORDELETE);
Steps.VerifyQueryDataCount(Config.Query_MonitoredSQLServers, "MonitoredSQLServers");
Steps.GetMonitoredServerID("select SQLServerID from MonitoredSQLServers where InstanceName =" + "'" + Config.ServerOptions_FORDELETE + "'", ref ServerID);
Steps.DeleteSQLServerInstance(Config.ServerOptions_FORDELETE);
Steps.VerifyInstanceIsDeleted("select * from AnalysisConfiguration where MonitoredServerID = " + ServerID, "AnalysisConfiguration");
Common.UpdateStatus(1); // 1 : Pass
}
catch (Exception ex)
{
Common.UpdateStatus(5); // 5 : fail
Reports.ReportLog(ex.Message, Reports.SQLdmReportLevel.Fail, null, Config.TestCaseName);
}
return(true);
}