/// <summary>Restores all schema tables, procedures and functions from content found in the specified restoration folder</summary> public void RestoreSchema(VEDelegate taskCompletion) { DateTime startTime = DateTime.Now; Memo("Memo", string.Format("/*\r\n**\t{0}\r\n**\tRestore Schema {1} - All Objects\r\n*/\r\n", BackupTimeStamp, targetObject.DatabaseSchema)); DropTables(); if (!Abort) { RestoreProcedures(); } if (!Abort) { RestoreFunctions(); } if (!Abort) { RestoreTables(taskCompletion); } Memo("Memo", string.Format("/*\r\n**\tRestore Schema {0} - All Objects: {1}\r\n*/\r\n", targetObject.DatabaseSchema, abort ? "ABORTED" : VETimeStamp.ElapsedTime(startTime))); }
public override void RestoreTables(VEDelegate taskCompletion) { DateTime startTime = DateTime.Now; int count = 0, schemaCount = 0; bool failed = false; Memo("Memo", string.Format("//\r\n//\t{0}\r\n//\tRestore User Tables: From {1}...\r\n" + "//\tRestore User Tables: To {2}...\r\n//\r\n", BackupTimeStamp, restoreObject.Tables, targetObject.ServerIDDatabaseSchema)); //.ServerIDDatabaseUser)); try { schemaCount = RestoreTableSchema(); if (!(failed = schemaCount <= 0)) { count = RestoreTableObjects(); } } catch (Exception e) { Memo("Memo", "VEAdmin.RestoreTables.Exception:\r\n\t" + e.Message); failed = true; } finally { Memo("Memo", string.Format("\r\n//\r\n//\tRestore User Tables: {0, 7:n0} Of {1:n0} Tables Restored" + "\r\n//\tRestore User Tables: {2, 7} {3}\r\n//\r\n", count, schemaCount, "**", Abort ? "Restoration Aborted" : failed ? "Restoration Failed" : VETimeStamp.ElapsedTime(startTime))); taskCompletion(); } }
public override void RestoreTables(VEDelegate taskCompletion) { DateTime startTime = DateTime.Now; int count = 0, schemaCount = 0; bool failed = false; string process = "Restore User Tables"; Memo("Start", string.Format("//\r\n//\t{0}\r\n//\t{1}: From {2}\r\n//\t{1}: [{3}]\r\n//\r\n//\t{1}: To {4}\r\n//\t{1}: [{5}]\r\n//\r\n", BackupTimeStamp, process, ZipFile.DatabaseSchema, ZipFile.FullFilename, targetObject.DatabaseSchema, targetObject.Server)); try { if (zipFile.HasSchemaTables()) { zipFile.Objects("Tables"); schemaCount = RestoreTableSchema(); if (!(failed = schemaCount <= 0)) { count = RestoreTableObjects(); } } else { VELog.Error("VEAdminZip.RestoreTables: database = " + zipFile.Database + "; schema = " + zipFile.Schema + "; HasNoTables"); } } catch (Exception e) { Error("VEAdminZip.RestoreTables Exception: ", e); failed = true; } finally { Memo(Abort || failed ? "Error" : "Totals", string.Format("\r\n//\r\n//\t{0}: {1, 7:n0} Of {2:n0} Tables Restored\r\n//\t{0}: {3, 7} {4}\r\n//\r\n", process, count, schemaCount, "**", Abort ? "Restoration Aborted" : failed ? "Restoration Failed" : VETimeStamp.ElapsedTime(startTime))); taskCompletion(); VELog.Error(string.Format("VEAdminZip.RestoreTables: min = {0}; max = {1}; max1024 = {2}; max2048 = {3} ", minCommand, maxCommand, maxCommand1024, maxCommand2048)); } }
/// <summary>Drops all schema tables and restores all tables specified in schema table '[selected path]\Tables\.veTableDependencies.dat'. /// Scripts for each table specified in the schema table must be found in the '[selected path]\Tables' folder to restore the table and /// a corresponding data content '.dat' file must be found in '[selected path]\Tables\Data' to repopulate the restored table</summary> public virtual void RestoreTables(VEDelegate taskCompletion) { }