public static void UpdateDataSet(this MSMO.View view, Data.ApplicationDataSet.DBViewsRow viewRow) { try { viewRow.CreateDate = view.CreateDate; //viewRow.DataSpaceUsed = view.DataSpaceUsed; try { viewRow.DateLastModified = view.DateLastModified; } catch (Exception ex) { PLLog.Warning(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 1); } viewRow.Owner = view.Owner; } catch (Exception ex) { // TODO(crhodes): Need to wrap anything above that throws an exception // that we want to ignore, e.g. property not available because of // SQL Edition. PLLog.Error(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 2); throw ex; } }
public static void UpdateDataSet(this MSMO.Table table, Data.ApplicationDataSet.DBTablesRow tableRow) { try { tableRow.DataSpaceUsed = table.DataSpaceUsed; try { tableRow.DateLastModified = table.DateLastModified; } catch (Exception ex) { PLLog.Warning(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 1); } tableRow.Owner = table.Owner; tableRow.RowCount = table.RowCount; } catch (Exception ex) { // TODO(crhodes): Need to wrap anything above that throws an exception // that we want to ignore, e.g. property not available because of // SQL Edition. PLLog.Error(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 2); throw ex; } }
public static void UpdateDataSet(this MSMO.Server server, Data.ApplicationDataSet.InstancesRow instanceRow) { try { try { instanceRow.BrowserStartMode = server.BrowserStartMode.ToString(); } catch (Exception ex) { PLLog.Warning(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 1); instanceRow.BrowserStartMode = "<Exception>"; } instanceRow.ServiceName = server.ServiceName; instanceRow.Collation = server.Collation; instanceRow.Edition = server.Edition; instanceRow.IsClustered = server.IsClustered; instanceRow.NetName = server.NetName; instanceRow.OSVersion = server.OSVersion; instanceRow.PhysicalMemory = server.PhysicalMemory; instanceRow.Platform = server.Platform; instanceRow.Processors = server.Processors; try { instanceRow.ServiceAccount = server.ServiceAccount; } catch (Exception ex) { PLLog.Warning(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 1); instanceRow.ServiceAccount = "<Exception>"; } try { instanceRow.ServiceInstanceId = server.ServiceInstanceId; } catch (Exception ex) { PLLog.Warning(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 1); instanceRow.ServiceInstanceId = "<Exception>"; } instanceRow.EngineEdition = server.EngineEdition.ToString(); instanceRow.Product = server.Product; instanceRow.ProductLevel = server.ProductLevel; instanceRow.Version = server.VersionString; } catch (Exception ex) { // TODO(crhodes): Need to wrap anything above that throws an exception // that we want to ignore, e.g. property not available because of // SQL Edition. PLLog.Error(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 2); throw ex; } }
public static void UpdateDataSet(this MSMO.StoredProcedure storedProcedure, Data.ApplicationDataSet.DBStoredProceduresRow storedProcedureRow) { try { storedProcedureRow.Owner = storedProcedure.Owner; storedProcedureRow.CreateDate = storedProcedure.CreateDate; if (Data.Config.ADSLoad_DBStoredProcedureContent) { try { storedProcedureRow.MethodName = storedProcedure.MethodName; } catch (Exception ex) { PLLog.Warning(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 1); storedProcedureRow.MethodName = "<Exception>"; } try { storedProcedureRow.TextHeader = storedProcedure.TextHeader; } catch (Exception ex) { PLLog.Warning(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 1); storedProcedureRow.TextHeader = "<Exception>"; } try { storedProcedureRow.TextBody = storedProcedure.TextBody; } catch (Exception ex) { PLLog.Warning(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 1); storedProcedureRow.TextBody = "<Exception>"; } } try { storedProcedureRow.DateLastModified = storedProcedure.DateLastModified; } catch (Exception ex) { PLLog.Warning(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 1); } } catch (Exception ex) { // TODO(crhodes): Need to wrap anything above that throws an exception // that we want to ignore, e.g. property not available because of // SQL Edition. PLLog.Error(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 2); throw ex; } }
public static void UpdateDataSet(this MSMO.Database database, Data.ApplicationDataSet.DatabasesRow databaseRow) { try { databaseRow.CreateDate = database.CreateDate; try { databaseRow.DataBaseGuid = database.DatabaseGuid.ToString(); } catch (Exception ex) { PLLog.Warning(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 1); databaseRow.DataBaseGuid = "<Not Available>"; } try { databaseRow.DataSpaceUsage = database.DataSpaceUsage; } catch (Exception ex) { PLLog.Warning(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 1); } try { if (database.ExtendedProperties.Count > 0) { try { databaseRow.EP_Area = (string)database.ExtendedProperties["EP_Area"].Value; } catch (Exception) { databaseRow.EP_Area = "[Not Set]"; } try { databaseRow.EP_DBApprover = (string)database.ExtendedProperties["EP_DBApprover"].Value; } catch (Exception) { databaseRow.EP_DBApprover = "[Not Set]"; } try { databaseRow.EP_DRTier = (string)database.ExtendedProperties["EP_DRTier"].Value; } catch (Exception) { databaseRow.EP_DRTier = "[Not Set]"; } try { databaseRow.EP_PrimaryDBContact = (string)database.ExtendedProperties["EP_PrimaryDBContact"].Value; } catch (Exception) { databaseRow.EP_PrimaryDBContact = "[Not Set]"; } try { databaseRow.EP_Team = (string)database.ExtendedProperties["EP_Team"].Value; } catch (Exception) { databaseRow.EP_Team = "[Not Set]"; } } } catch (Exception ex) { // ExtendedProperties.Count throws exceptions on SQL2000?? } try { databaseRow.IndexSpaceUsage = database.IndexSpaceUsage; } catch (Exception ex) { PLLog.Warning(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 1); } try { databaseRow.LastBackupDate = (database.LastBackupDate > SQLMinDateTime ? database.LastBackupDate : SQLMinDateTime); } catch (Exception ex) { PLLog.Warning(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 1); } try { databaseRow.LastDifferentialBackupDate = (database.LastDifferentialBackupDate > SQLMinDateTime ? database.LastDifferentialBackupDate : SQLMinDateTime); } catch (Exception ex) { PLLog.Warning(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 1); } try { databaseRow.LastLogBackupDate = (database.LastLogBackupDate > SQLMinDateTime ? database.LastLogBackupDate : SQLMinDateTime); } catch (Exception ex) { PLLog.Warning(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 1); } databaseRow.Owner = database.Owner; databaseRow.RecoveryModel = database.RecoveryModel.ToString(); try { databaseRow.Size = database.Size; } catch (Exception ex) { PLLog.Warning(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 1); } try { databaseRow.SpaceAvailable = database.SpaceAvailable; } catch (Exception ex) { PLLog.Warning(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 1); } } catch (Exception ex) { // TODO(crhodes): Need to wrap anything above that throws an exception // that we want to ignore, e.g. property not available because of // SQL Edition. PLLog.Error(ex, PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 2); throw ex; } }